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;


This Question Belongs to SQL >> Sql Miscellaneous

Join The Discussion

Comments ( 1 )

  1. Muhammed Hussin
    Muhammed Hussin :
    10 months ago

    What is the result of the ROUND(7.384, 1) function in Oracle SQL ?

Related Questions on Sql Miscellaneous