Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

IN Predicate

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:

Basic Predicate

TOCIndex