Which of the following queries can be used to delete duplicate records from a table -
delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name);
delete from table_name where rowid in (select max(rowid) from table group by duplicate_values_field_name);
c)delete from table_name where rowid not in (select max(rowid) from table);
delete from table_name where rowid not in (select rowid from table group by duplicate_values_field_name);