Which SQL statement is used to return only different values?

Question

A) SELECT UNIQUE

B) SELECT INDENTITY

C) SELECT DIFFERENT

D) SELECT DISTINCT

Answer 1

The correct answer is option D (Select distinct). Select distinct statement is used to return only different values that match the specified criteria. The following is the syntax to use select distinct statement:

Select DISTINCT column_1, column_2,……

FROM TableName

WHERE condition(s);

For examples, if we wish to find the distinct salaries of employees from the Employee table and sort them in order:

SELECT DISTINCT Salary

FROM Employee

ORDER BY Salary;

If you are looking for a SQL certification, then take up this SQL certification course by Intellipaat that provides instructor-led training and certification.