Which of the following command is used with SQL SELECT statement in Oracle to return only distinct…

Question

Which of the following command is used with SQL SELECT statement in Oracle to return only distinct (different) values?

Accepted Answer

Correct answer: C — In Oracle SQL, the DISTINCT keyword is used with SELECT to return only unique rows. UNIQUE is not a valid clause for this purpose in standard SELECT statements.

Answer

A. UNIQUE

Answer

B. DIFFERENT

Answer

C. DISTINCT

Answer

D. SINGLE

Which of the following command is used with SQL SELECT statement in Oracle to…