UNION ALL in SQL

UNION ALL in SQL — a practical guide to SQL UNION ALL with clear examples you can reuse in real projects.

SQL Tutorial Series (55/100). Prefer one article? Read the complete SQL tutorial.

Short description

Usually faster than UNION when duplicates are acceptable.

Union all

SELECT email FROM customers
UNION ALL
SELECT email FROM subscribers;