Google News
logo
Oracle - Quiz(MCQ)
Which of the following command is used to SELECT only one copy of each set of duplicable rows in SQL?
A)
SELECT DIFFERENT
B)
SELECT UNIQUE
C)
SELECT DISTINCT
D)
All of the above

Correct Answer :   SELECT DISTINCT


Explanation : The keyword allows us to grab all information from a column (or columns) on a table. This, of course, necessarily means that there will be redundancies. What if we only want to select each distinct element? This is easy way to accomplish in SQL. All we need to do is that to add after The syntax is: SELECT DISTINCT column_name FROM table_name;.

Advertisement