UNIQUE Predicate Purpose The Unique predicate is used to determine whether duplicate rows exist in a virtual table (one returned from a subquery). Syntax UNIQUE (subquery) Example SELECT * FROM dept d WHERE UNIQUE (SELECT deptno FROM emp e WHERE e.deptno = d.deptno)