WHERE clause

The WHERE clause lists search conditions for items to add to a result set. The WHERE clause contains search conditions composed of the following:

• literal values

• input parameters

• expressions

• basic predicates

• quantified predicates

• BETWEEN predicate

• IN predicate

• LIKE predicate

• NULL predicate

• EMPTY collection predicate

• MEMBER OF predicate

• EXISTS predicate

• IS OF TYPE predicate

If the search condition evaluates to TRUE, the tuple is added to the result set.

Sub-topics

Related concepts

Related tasks