Teradata SQL supports the following set operators:
| Set Operator | Function |
|---|---|
| INTERSECT | Returns result rows that appear in all answer sets generated by the individual SELECT statements. |
| MINUS /EXCEPT | Result is those rows returned by the first SELECT except for those also selected by the second SELECT. MINUS is the same as EXCEPT. |
| UNION | Combines the results of two or more SELECT statements. |
Set operators appear in query expressions. A query expression is a set of queries combined by the set operators INTERSECT, MINUS/EXCEPT, and UNION.