WAS v8.5 > Develop applications > Develop Dynamic and EJB query > Develop applications that use EJB query > EJB query language > WHERE clauseIN predicate
The IN predicate compares a value to a set of values.
It can have one of two forms:
expression [NOT] IN ( subselect )
expression [NOT] IN ( value1, value2, .... )
ValueN can either be a literal value or an input parameter. The expression cannot evaluate to a reference type.
Example: IN predicate
e.salary IN ( 10000, 15000 )
is equivalent to
( e.salary = 10000 OR e.salary = 15000 )
e.salary IN ( select e1.salary from EmpBean e1 where e1.dept.deptno = 10)
is equivalent to
e.salary = ANY ( select e1.salary from EmpBean e1 where e1.dept.deptno = 10)
e.salary NOT IN ( select e1.salary from EmpBean e1 where e1.dept.deptno = 10)
is equivalent to
e.salary <> ALL ( select e1.salary from EmpBean e1 where e1.dept.deptno = 10)
Related concepts:
EJB query language
WHERE clause
Related
Use EJB query