{ expression | ( expression [,...] ) }
{ comparison_operator | [NOT] IN ( in_list ) }
[ ANY | SOME | ALL ] (subquery)
Syntax Elements
- expression
- SQL expression.
- To specify multiple expressions, enclose the expressions in PARENTHESIS characters and separate each expression with a COMMA character.
- comparison_operator
- SQL comparison operator.
- See Comparison Operators and Functions for information about the SQL comparison operators.
- IN (in_list)
- expression is either IN the parenthetically delimited list of values.
- For information about the IN logical predicates and the valid expressions that you can specify in an in_list, see IN/NOT IN.
- NOT IN (in_list)
- expression is NOT IN the parenthetically delimited list of values.
- For information about the NOT IN logical predicates and the valid expressions that you can specify in an in_list, see IN/NOT IN.
- ANY
- The ANY logical quantifier.
- For more information about the ANY logical quantifier, see ANY/ALL/SOME Quantifiers.
- SOME
- See ANY/ALL/SOME Quantifiers.
- ALL
- The ALL logical quantifier.
- For more information about the ALL logical quantifier, see ANY/ALL/SOME Quantifiers.
- subquery
- SQL subquery.