IN predicate
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
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');