UNIQUE predicate
The UNIQUE predicate is used to determine if 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);
