Multiple choice technology databases

Which SQL keyword is used to retrieve only unique values?

  1. DISTINCTIVE

  2. UNIQUE

  3. DISTINCT

  4. DIFFERENT
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

DISTINCT is used in SELECT statements to eliminate duplicate rows from the result set, returning only unique values. For example, SELECT DISTINCT city FROM customers returns a list of unique cities. UNIQUE is a constraint, not a query keyword.

Keep practicing — related questions