The SELECT statement can use the set operators UNION, INTERSECT, and MINUS/EXCEPT. These set operators enable you to manipulate the answers to two or more queries by combining their results into a single result set.
You can use the set operators with operations like the following:
- View definitions
- Derived tables
- Subqueries