A condition specifies a combination of one or more expressions and logical operators that evaluates to either TRUE, FALSE, or UNKNOWN. You can use a condition in the Where clause of the Delete, Select, and Update statements; and in the Having clauses of Select statements. The following describes supported conditions.

Table 1. Conditions
Condition Description
Simple comparison Specifies a comparison with expressions or subquery results.
= , !=, <>, < , >, <=, <=
Group comparison Specifies a comparison with any or all members in a list or subquery.
[= , !=, <>, < , >, <=, <=] [ANY, ALL, SOME]
Membership Tests for membership in a list or subquery.
[NOT] IN
Range Tests for inclusion in a range.
[NOT] BETWEEN
NULL Tests for nulls.
IS NULL, IS NOT NULL
EXISTS Tests for existence of rows in a subquery.
[NOT] EXISTS
LIKE Specifies a test involving pattern matching.
[NOT] LIKE
Compound Specifies a combination of other conditions.
CONDITION [AND/OR] CONDITION