Multiple choice technology databases

Duplicate values are eliminated by which keyword

  1. Duplicate

  2. Distinct

  3. Remove

  4. Delete
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In SQL, the DISTINCT keyword is used in SELECT statements to remove duplicate rows from the result set, returning only unique values. While options like 'Duplicate', 'Remove', and 'Delete' might seem conceptually related, they are not valid SQL keywords for this purpose. DISTINCT is the standard SQL operator specifically designed for eliminating duplicate values.

Keep practicing — related questions