Home » MCQs » SQL MCQs » SQL Basics (Set 2) MCQs

What does the DISTINCT Clause do?

16. What does the DISTINCT Clause do?

1. Specify the columns of the table in this SQL clause to return distinct values.
2. By executing this SQL statement, all records in the SQL database will be deleted.
3. The data specified in this table or view is reported in this SQL statement.
4. Changes made in the SQL database transaction are permanently saved using this SQL statement.

Answer: A) Specify the columns of the table in this SQL clause to return distinct values

Explanation:

Specify the columns of the table in DISTINCT SQL clause to return distinct values.