删除oracle表里的重复记录

查找表里的重复记录

select count(*) fromtable_name where rowid in (select a.rowid fromtable_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 fromtable_name where rowid in (select a.rowid fromtable_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);