Multiple choice technology databases

Which SQL statement is used to return only different values?

  1. SELECT UNIQUE

  2. SELECT DISTINCT

  3. SELECT DIFFERENT

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

SELECT DISTINCT eliminates duplicate values from results, returning only unique rows. The other options (UNIQUE, DIFFERENT, SAME) are not valid SQL keywords for this purpose.

Keep practicing — related questions