Which operator is used to combine the distinct result sets of two or more SELECT queries into a single output, automatically filtering out duplicate rows? MCQ with Answer and Explanation
Which operator is used to combine the distinct result sets of two or more SELECT queries into a single output, automatically filtering out duplicate rows?
A. EXCEPT
B. INTERSECT
C. UNION
D. UNION ALL
Answer: Option C
Solution (By JKSSB Mock Tests)
The UNION operator merges the result sets of two queries, removing any duplicate records. UNION ALL performs a similar merge but retains duplicates.
No comments yet. Be the first to start the discussion!