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