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?
Explanation:
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!