0 votes
1 view
in SQL by (53.7k points)

A) SELECT UNIQUE

B) SELECT INDENTITY

C) SELECT DIFFERENT

D) SELECT DISTINCT

1 Answer

0 votes
by (116k points)

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.

Related questions

+1 vote
1 answer
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...