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: If the search condition evaluates to TRUE, the tuple is added to the result set.



Subtopics
Literals
Input parameters
WebSphere® Application Server, 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
Related concepts
EJB query language
Related tasks
Using EJB query
Concept topic Concept topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Jun 11, 2013 8:40:09 AM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=v701sca&product=was-nd-mp&topic=cque_where
File name: cque_where.html