Multiple choice technology databases

Which SQL statement is used to return only different values?

  1. SELECT DIFFERENT

  2. SELECT DISTINCT

  3. SELECT UNIQUE

  4. All of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SELECT DISTINCT eliminates duplicate values. DIFFERENT is not a SQL keyword, and UNIQUE (though valid in some databases) is not standard SQL.

Keep practicing — related questions