Quantified predicates

A quantified predicate compares a value with a set of values produced by a subselect.

expression   comparison-operator   SOME  |  ANY  |   ALL    ( subselect )

The expression must not evaluate to a reference type.

When SOME or ANY is specified the result of the predicate is as follows:

When ALL is specified the result of the predicate is as follows:


Related concepts
EJB query language
WHERE clause
Related tasks
Using EJB query



Searchable topic ID:   cque_quanpred
Last updated: Jun 21, 2007 4:55:42 PM CDT    WebSphere Application Server Network Deployment, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/ae/cque_quanpred.html

Library | Support | Terms of Use | Feedback