oracle删除重复数据

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);