skip to main content
Querying data stores with SQL : Supported SQL and Extensions : SQL Expressions : Conditions
  

Try Now
Conditions
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 203. 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