Wipro Interview Question:

How to delete Duplicate row in table of Wipro?

Submitted by: Muhammad

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