Set operation

Also written: set operations, UNION, UNION ALL

UNION, UNION ALL, INTERSECT and EXCEPT combine the results of two whole queries, one above the other. Both queries need the same number of columns, and UNION removes duplicates while UNION ALL keeps them.