ExamVeda
Login
Home
This question belongs to Database Introduction To SQL
Introduction to SQL
?

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.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.