Multiple choice technology databases

  1. Which SQL statement is used to return only different values?

  1. SELECT UNIQUE

  2. SELECT DISTINCT

  3. SELECT DIFFERENT

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

The DISTINCT keyword in SQL removes duplicate values and returns only unique values. Option B is correct. SELECT UNIQUE and SELECT DIFFERENT are not valid SQL keywords.

Keep practicing — related questions