Oracle: 怎样用一条SQL语句删除表中字段重复的记录
[解决办法]
以测试过删除了重复记录
delete from emp
where empno in
(select empno from emp group by empno having count(empno) > 1)
and rowid not in
(select min(rowid) from emp group by empno having count(empno) > 1)
[解决办法]
delete from emp a where rowid<>(select min(rowid) from emp b where a.empno=b.empno)
