How will you delete duplicating rows from a base table?

Question

Hello
How will you delete duplicating rows from a base table in oracle?
please reply me. i am waiting for your reply.
Thanx

Answer 1

delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name); or delete duplicate_values_field_name dv from table_name ta where rowid <(select min(rowid) from table_name tb where ta.dv=tb.dv);