Multiple choice technology

Which keyword will be used in SQL statement in order to return only different values?

  1. DIFFERENT

  2. DISTINCT

  3. UNIQUE

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

The DISTINCT keyword in SQL eliminates duplicate rows from query results, returning only unique values. Option A (DIFFERENT) is not valid SQL syntax. UNIQUE is a constraint, not a query keyword for filtering duplicates. ALL returns all rows including duplicates (default behavior).

Keep practicing — related questions