SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.
A. True
B. False
Answer: Option B
Solution (By Examveda Team)
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.
This Question Belongs to Database >> Introduction To SQL
Join The Discussion