EXISTS predicate
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
The EXISTS predicate is true only if the cardinality of the subquery is greater than 0 and is false otherwise.
Syntax
EXISTS subquery
Example
SELECT empno, ename, deptno FROM emp e
WHERE EXISTS (SELECT deptno FROM dept WHERE e.deptno = dept.deptno);