Lesson 1 of 6 in this module

16/33 in track

Set operations: UNION, INTERSECT, EXCEPT

sql10 min

Locked lessonAdvanced Querying

Set operations: UNION, INTERSECT, EXCEPT

UNION stacks two SELECTs. INTERSECT keeps the overlap. EXCEPT keeps rows only on the left.