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.