摘要：
Oracle利用rowid删除表中重复记录先看表myemp查出有重复数据的记录查出没有重复数据的记录查出不重复的记录或者select * from myemp e where rowid = (select max(rowid) from myemp e2 where e.userid = e2.userid and e.username = e2.username and e.salary = e2.salary)如何删除重复数据1、 当有大量重复数据存在并且在列userid,username,salary上有索引的情况下delete myemp where rowid not in (se 阅读全文