SQL, PL-SQL, and Java Programming Quiz
Casual Mode - Take your time!
1 / 20
Correct
0
Incorrect
0
Score
0%
Multiple Choice
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);