Oracle查询某些字段的重复记录及删除

查询某些字段的重复记录

select a.col1,a.col2 from tablename a, 
(select col1,col2 from tablename group by col1,col2 having count(*)>1) b 
where a.col1=b.col1 and a.col2=b.col2

–保留最新的一条

DELETE FROM TABLE_NAME 
WHERE ROWID NOT IN
(SELECT MAX(ROWID) FROM TABLE_NAME D  group by d.col1,d.col2);