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.