Vidyalelo
Database · Q44

Introduction to SQL

Programming · Database · question 44

Q44

SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.

A.
True
B.
False
Answer

Answer: Option B

Solution

Answer: Option B
Solution:
Option B: False - The statement is incorrect. SELECT DISTINCT is used to retrieve unique rows from a query result. It eliminates duplicate rows from the output of a SELECT statement, not columns.

Option A: True - This option is incorrect. Using SELECT DISTINCT ensures that duplicate rows are not returned in the result set, rather than duplicate columns.

Conclusion:
The statement "SELECT DISTINCT is used if a user wishes to see duplicate columns in a query" is Option B: False. Therefore, the correct answer is False.