Examveda
Examveda

Which SQL keyword is used to retrieve only unique values?

A. DISTINCTIVE

B. UNIQUE

C. DISTINCT

D. DIFFERENT

Answer: Option C

Solution(By Examveda Team)

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;

Join The Discussion

Related Questions on Sql Miscellaneous