Combine Result Sets
Set operations combine two SELECT results with matching column counts and compatible types. UNION removes duplicates, UNION ALL keeps them, INTERSECT keeps common rows, and EXCEPT keeps left-only rows.
GOAL
Predict rows retained by UNION-family operations.
Which set operation keeps duplicates?