Teradata SQL supports the following set operators:
|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.