y IN (x, ..., z)

The IN predicate returns true if y is equal to one of the values in the list (x, ..., z).

(x, ..., z) represents a list of expressions, each of which must evaluate to a single value. If there is only one expression in the list, the parentheses are optional. None of the expressions (y, x, or z) can be subqueries.

y NOT IN (x, ..., z)

Returns true if y is not equal to any of the values in the list (x, ..., z).

(x, ..., z) is a list of expressions, each of which must evaluate to a single value. If there is only one expression in the list, the parentheses are optional. None of the expressions (y, x, or z) can be subqueries.

y IN (subquery)

Returns true if y is equal to one of the values returned by the subquery. The subquery must be parenthesized and can reference only one column in its SELECT clause.

y NOT IN (subquery)

Returns true if y is not equal to any of the values returned by the subquery. The subquery must be specified in parentheses and can reference only one column in its SELECT clause.