SQL> delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name).