📚 Practice Mode

SQL, PL-SQL, and Java Programming Quiz

Learn at your own pace with hints and detailed explanations

1 / 20
Multiple Choice

Which of the following queries can be used to delete duplicate records from a table -

  1. delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name);
  2. delete from table_name where rowid in (select max(rowid) from table group by duplicate_values_field_name);
  3. c)delete from table_name where rowid not in (select max(rowid) from table);
  4. delete from table_name where rowid not in (select rowid from table group by duplicate_values_field_name);
Change Mode