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.

Syntax

This is the syntax for an IN predicate:

 expression [ NOT ] IN
  { (query_expression) | (constant , constant[ , ...] )  }

Example

address.state IN (‘MA', ‘NH')