Q11
Which SQL keyword is used to retrieve only unique values?
A.
DISTINCTIVE
B.
UNIQUE
C.
DISTINCT
AnswerD.
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;