Multiple choice technology databases

Which SQL statement is used to return only different values

  1. SELECT DIFFERENT

  2. SELECT DISTINCT

  3. SELECT COUNT

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

SELECT DISTINCT returns only unique (different) values from the specified columns, eliminating duplicate rows. SELECT DIFFERENT and SELECT UNIQUE are not valid SQL syntax. SELECT COUNT returns the count of rows, not distinct values.

Keep practicing — related questions