SQL · Joins and set operations

union

Stacks result sets and removes duplicates. Column counts and compatible types must match.

sqlRunnable example sql course

Syntax

select … union select …

Example

Open in the lab

SELECT 'HTML' AS title UNION SELECT 'CSS' UNION SELECT 'HTML';

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.