Vidyalelo
SQL · Q11

SQL

Programming · SQL · question 11

Q11

Which SQL keyword is used to retrieve only unique values?

A.
DISTINCTIVE
B.
UNIQUE
C.
DISTINCT
Answer
D.
DIFFERENT

Answer: Option C

Solution

Answer: Option C
Solution:

This command is used to select the distinct rows.
For Example: If we want to select all distinct department names from employee table, the query would be:
SELECT DISTINCT dept FROM employee;