Name

EXISTS — Test if a row exists

Syntax

Description

The EXISTS operator returns a logic value (integer 0 or 1) depending on whether the SELECT statement returns any rows. The number of columns and their values are irrelevant. As long as the SELECT statement returns at least one row consisting of at least one column, the operator will return true—even if the column value is a NULL.

See Also

IN, BETWEEN