delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name);

delete duplicate_values_field_name dv from table_name ta where rowid

delete ename from emp a where rowid < ( select min(rowid) from emp b where a.ename = b.ename);

Delete all