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)