?
SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.
Answer & Solution
Correct Answer:
Option
B
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.
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.
Join the Discussion
Login to post a comment or share your explanation.
Login