Network Deployment (Distributed operating systems), v8.0 > Develop and deploying applications > Develop Dynamic and EJB query > Develop applications that use EJB query > EJB query language
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.
Related
Literals
Input parameters
WAS, 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
Use EJB query