Which SQL keyword is used to retrieve only unique values?
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;
A. Data Definition Language(DDL)
B. Data Manipulation Language(DML)
C. Both of above
A. EXISTS operator
B. NOT operator
C. IS NULL operator
D. None of these