How to remove duplicates in the table ?

Delete from EMP where rowid not in (select max (rowid) from EMP group by empno);