How to delete duplicate rows in a table?

                                                                                                                                                                      

Scenario:

How to delete duplicate rows in a table?

Solution:

delete from emp a where rowid != (select max(rowid) from emp b where  a.empno=b.empno);

OR

delete from emp a where rowid != (select min(rowid) from emp b where  a.empno=b.empno);