WHERE clause

The WHERE clause contains search conditions composed of the following...

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

 

See Also

Literals
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
EJB query language
Using EJB query