|
|
|
Description
The IN predicate can be used to compare a value with a set of values. If an IN predicate specifies a query expression, then the result table it returns can contain only a single column. This predicate can be used inside of a WHERE, HAVING, or JOIN statement.
Syntax
in_predicate ::
expr [ NOT ] IN { ( query_expression ) |
( constant , constant [ , ... ] ) }
Example
address.state IN ('MA', 'NH')
See also:
