where:
Syntax element … |
Specifies … |
expression |
any valid SQL expression. To specify multiple expressions, enclose them within PARENTHESIS characters and separate each expression with a COMMA character. |
comparison_operator |
any valid SQL comparison operator. See SQL Functions, Operators, Expressions, and Predicates for information about the SQL comparison operators. |
IN (in_list) NOT IN (in_list) |
that expression is either IN or NOT IN the parenthetically delimited list of values. See SQL Functions, Operators, Expressions, and Predicates for information about the IN and NOT IN logical predicates and the valid expressions that you can specify in an in_list. |
ANY |
the ANY logical quantifier. See SQL Functions, Operators, Expressions, and Predicates for more information about the ANY logical quantifier. |
SOME |
the SOME logical quantifier. See SQL Functions, Operators, Expressions, and Predicates for more information about the SOME logical quantifier. |
ALL |
the ALL logical quantifier. See SQL Functions, Operators, Expressions, and Predicates for more information about the ALL logical quantifier. |
subquery |
any valid SQL subquery. |