oracle删除表重复数据
当表里的每条数据都有345678条一模一样的数据时,我们需要删除的话,就使用下面的语句来删除:
delete from student where name in(select name from student group by name)
and rowid not in (select min(rowid) from student group by name)
再看表:
delete from student where name in(select name from student group by name)
and rowid not in (select min(rowid) from student group by name)
再看表: