+

Search Tips   |   Advanced Search

 

IN 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 tasks


Use EJB query