Set Operations — UNION, INTERSECT, EXCEPT — Free SQL Tutorial

Learn Set Operations — UNION, INTERSECT, EXCEPT in SQL with a free, beginner-friendly tutorial, examples and practice for Indian students on Syllab.in.

Set Operations — UNION, INTERSECT, EXCEPT — Free SQL Tutorial

Learn Set Operations — UNION, INTERSECT, EXCEPT in SQL with a free, beginner-friendly tutorial, examples and practice for Indian students on Syllab.in.

✓ 100% Free ✓ No Login Needed ✓ NCERT / CBSE Aligned ✓ Download as PDF

TL;DR: Learn Set Operations — UNION, INTERSECT, EXCEPT in SQL with a free, beginner-friendly tutorial, examples and practice for Indian students on Syllab.in…

Written & reviewed by the Syllab.in Academic Team (CBSE/NCERT subject experts) · Updated

🤖 Stuck on any question? Ask Syllab's free AI Tutor for a step-by-step explanation — instant, unlimited, no login.

Set Operations — UNION, INTERSECT, EXCEPT in SQL

UNION combines results from two or more queries into a single result, removing duplicates. UNION ALL keeps duplicates.

INTERSECT returns only rows that appear in both queries. EXCEPT returns rows from the first query that don't appear in the second.

All queries must have the same number of columns with compatible types. Column names come from the first query.

Set Operations — UNION, INTERSECT, EXCEPT — Syntax

SELECT col FROM table1
UNION
SELECT col FROM table2;

SELECT col FROM table1
INTERSECT
SELECT col FROM table2;

SELECT col FROM table1
EXCEPT
SELECT col FROM table2;

Learn Set Operations — UNION, INTERSECT, EXCEPT step by step with Syllab's free interactive SQL tutorial — runnable code examples, practice exercises and instant AI feedback, all free with no signup. Explore the full SQL course →