Oracle根据ROWID查询、删除多字段重复数据

一、查询重复数据

SELECT * FROM demo t1 WHERE t1.ROWID NOT IN ( SELECT MIN(t2.ROWID) FROM demo t2 GROUP BY id,name)

一、删除重复数据

DELETE FROM demo WHERE ROWID IN (SELECT ROWID from demo t1 WHERE t1.ROWID NOT IN ( SELECT MIN(t2.ROWID) FROM demo t2 GROUP BY id,name ))