Home » MCQs » SQL MCQs » SQL Functions MCQs

Which of the following statement is TRUE about DISTINCT Clause?

20. Which of the following statement is TRUE about DISTINCT Clause?

1. Returns only Distinct values.
2. Only on the single column, it operates.
3. It can be used with the aggregates such as COUNT, AVG, etc.
4. All of the above

Answer: D) All of the above

Explanation:

1. DISTINCT can return only distinct values.
2. DISTINCT operates only on the single column
3. DISTINCT can be used with the aggregates such as COUNT, AVG, etc.