【SQL】去除表中的重复行

去除emp表中相同的行：

SCOTT@LGR> delete from emp a where rowid not in (select max(rowid) from emp b where a.empno=b.empno);