How to Delete duplicate Records from the table in SQL

DELETE FROM emp

      WHERE ROWID NOT IN (SELECT   MAX (ROWID)

                              FROM emp

                          GROUP BY empno);