Millionaire Mode

SQL, PL-SQL, and Java Programming Quiz

Question 1 of 20

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);

Prize Money

15₹7 Crores
14₹1 Crore
13₹50,00,000
12₹25,00,000
11₹12,50,000
10₹6,40,000
9₹3,20,000
8₹1,60,000
7₹80,000
6₹40,000
5₹20,000
4₹10,000
3₹5,000
2₹2,000
1₹1,000