Question

Which SQL statement is used to return only different values?

(a) SELECT DIFFERENT

(b) SELECT UNIQUE

(c) SELECT DISTINCT

(d) SELECT ALL

I got this question in unit test.

This is a very interesting question from Basic SQL in chapter Laying the Foundation of SQL Server

Answer 1

Correct answer is (c) SELECT DISTINCT

The explanation is: The SELECT DISTINCT statement is used to return only distinct (different) values.