## Deleting duplicate rows from a table


   DELETE FROM EMP E
   WHERE  E.ROWID > ( SELECT MIN(X.ROWID)
                      FROM   EMP X
                      WHERE  X.EMP_NO = E.EMP_NO );