How to delete the duplicate values from table ?

To Delete duplicate values from the table we have to execute  the  query given below.

delete from emp where rowid not in (select min(rowid) from emp group by empno);