bofengshuimen0的博客

转载 oracle 查找或删除重复记录的语句

oracle 查找或删除重复记录的语句--oracle查找重复记录select * from  tableA  a where a.rowid>(select min(rowid) from tableB b where a.column=b.column)             --oracle删除重复记录delete from  tableA  a where a.rowid>(...