Multiple choice technology databases

Which SQL statement is used to return only different values?

  1. SELECT DIFFERENT

  2. SELECT UNIQUE

  3. SELECT DISTINCT

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

The DISTINCT keyword in SQL eliminates duplicate rows from the result set, returning only unique (different) values. The correct syntax is 'SELECT DISTINCT column_name' as shown in option C. Options A, B, and D use keywords that don't exist in standard SQL for this purpose.

Keep practicing — related questions