删除重复数据

删除重复数据，虽然知道这两条语句很久了，还是记录一下吧
DELETE  FROM  EMP1 E  WHERE  E.ROWID > (SELECT MIN(X.ROWID) FROM  EMP1 X  WHERE  X.EMPNO = E.EMPNO);
DELETE FROM  TEST1  A WHERE EXISTS (SELECT 1 FROM TEST1 B WHERE A.EMPNO=B.EMPNO AND A.ROWID>B.ROWID);