SQL

UNION

English

Overview

An operator that stacks multiple SELECT results together, removing duplicates.

Details

A set operator that stacks multiple SELECT results vertically and automatically removes duplicate rows. UNION ALL, which allows duplicates, is also available.

More Database terms