0
In SQL, which command is used to SELECT only one copy of each set of duplicable rows
- ASELECT DISTINCT
- BSELECT UNIQUE
- CSELECT DIFFERENT
- DAll of the above
Correct answer: A
Discussion 1
Log in or create a free account to reply and vote.
0
CCommunity
SELECT DISTINCT
The SELECT 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 DISTINCT after SELECT. The syntax is as follows:
SELECT DISTINCT column_name
FROM table_name;
The SELECT 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 DISTINCT after SELECT. The syntax is as follows:
SELECT DISTINCT column_name
FROM table_name;