How to delete the duplicate rows from the table?

delete from emp a

      Where rowid > (select min (rowid) from emp b

                              where a.empno =b.empno)