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 table 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