skip to main content
Expressions, conditions, and queries : Subqueries : IN predicate
 

IN predicate

Syntax 

value [NOT] IN (value1, value2,...)
OR
value [NOT] IN subquery

Example 

SELECT * FROM emp W
HERE deptno IN (SELECT deptno FROM dept WHERE dname = 'Sales');