You can use set operators within the following operations:
- Simple queries
- Derived tables You cannot use the HASH BY or LOCAL ORDER BY clauses in derived tables with set operators.
- Subqueries
- INSERT … SELECT clauses
- View definitions
SELECT statements connected by set operators can include all of the normal clause options for SELECT except the WITH clause.