Multiple choice technology databases

Which SQL keyword is used to retrieve only unique values?

  1. UNIQUE

  2. DIFFERENT

  3. DISTINCT

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

DISTINCT is the SQL keyword used to retrieve only unique values from a column, eliminating duplicate rows in the result set. UNIQUE is a constraint used during table creation to enforce uniqueness, not for data retrieval. DIFFERENT and DISTINCTIVE are not valid SQL keywords.

Keep practicing — related questions