Home » MCQs » SQL MCQs » SQL Statements and Clauses MCQs

In order to delete duplicate rows from the table, which keyword is used?

28. In order to delete duplicate rows from the table, which keyword is used?

1. DELETE
2. DISTINCT
3. FROM
4. WHERE

Answer: B) DISTINCT

Explanation:

DISTINCT keyword is used to delete duplicate rows from the table.