oracle删除重复行（相同记录只保留一条）

DELETE
FROM
	table  t
WHERE
	corp_name  IN 
		(
			SELECT
				corp_name
			FROM
				table
			GROUP BY
				corp_name
			HAVING
				COUNT(corp_name) > 1
		)
	AND ROWID NOT IN 
		(
			SELECT
				MIN(ROWID)
			FROM
				table
			GROUP BY
				corp_name
			HAVING
				COUNT(*) > 1
		);

如上所示，删除表中corp_name列重复的记录，只保留一条。