Multiple choice technology databases

Which SQL statement is used to return only different values?

  1. SELECT DIFFERENT

  2. SELECT DISTINCT

  3. SELECT UNIQUE

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

The SELECT DISTINCT statement is standard SQL syntax used to filter out duplicate rows and return only unique values from the query result. Commands like DIFFERENT, UNIQUE, and SEPARATE are not standard SQL keywords for removing duplicate records from a query result.

Keep practicing — related questions