The SELECT statement can use the set operators UNION, INTERSECT, and MINUS/EXCEPT. These set operators allow you to manipulate the answers to two or more queries by combining the results of each query into a single result set.
You can use the set operators within, for example, the following operations:
- View definitions
- Derived tables
- Subqueries