How Can We Delete Duplicate Row In Table?

1.	How Can We Delete Duplicate Row In Table?
Answer» SQL&GT; delete from table_name where rowid not in (SELECT MAX(rowid) from table group by duplicate_values_field_name); SQL> delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name);

Answer»

SQL&GT; delete from table_name where rowid not in (SELECT MAX(rowid) from table group by duplicate_values_field_name);

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

Discussion