EXISTS predicate
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);
