Sql Union Intersect Except — Free Sql Tutorial

TL;DR: Learn Sql Union Intersect Except in Sql with a free, beginner-friendly tutorial, examples and practice for Indian students on Syllab.in.

Sql 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.

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 Sql 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 →