删除oracle表里的重复记录

查找表里的重复记录

select count(*) from table_name where rowid in (select a.rowid from table_name a, table_name b where a.rowid < b.rowid and a.col1=b.col1 and a.col2 = b.col2 and a.col3=b.col3);

 

 

删除表里的重复记录

delete from table_name where rowid in (select a.rowid from table_name a, table_name b where a.rowid < b.rowid and a.col1=b.col1 and a.col2 = b.col2 and a.col3=b.col3);