oracle删除表中某些字段重复的数据
DELETE FROM TABLE_NAME A WHERE (A.FIELD1, A.FIELD2) IN (SELECT FIELD1, FIELD2 FROM TABLE_NAME GROUP BY FIELD1, FIELD2 HAVING COUNT(*) > 1) AND ROWID NOT IN (SELECT MIN(ROWID) FROM TABLE_NAME GROUP BY FIELD1, FIELD2 HAVING COUNT(*) > 1);
抱怨有用的话还要努力干什么