Learn VisualLearn SQL

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?