Tests the existence of the value of an expression or expression list in a comparable set in one of two ways:
- Compares the value of an expression with values in an explicit list of literals.
- Compares values in a list of expressions with values and in a set of corresponding expressions in a subquery.
See the following sections:
ANSI Compliance
This statement is ANSI SQL:2011 compliant.
Using TO in a list of literals is a Teradata extension to the ANSI standard.
expression IN and NOT IN expression or literals