oracle删除重复数据
DELETE FROM LN_TOS_DOCSEAL WHERE id IN (SELECT
v.ID
FROM
(
SELECT
a.*,
ROW_NUMBER() OVER(PARTITION BY a.CITY, a.DIST, a.BPMFILECODE, a.BIZTYPE, a.PRODUCTCODE, a.BIZTYPE , a.SEALCODE , a.SEALKEYWORD , a.SEALSTYLE , a.SEALTYPECODE
,a.STAMPSEAL ORDER BY 1) rn
FROM
(
SELECT
Id,
CITY,
DIST,
BPMFILECODE,
PRODUCTCODE,
BIZTYPE,
SEALCODE,
SEALKEYWORD,
SEALSTYLE,
SEALTYPECODE,
STAMPSEAL
FROM
LN_TOS_DOCSEAL
WHERE BIZTYPE = '1'
) a
) v
WHERE
v.rn = 2);