Returns True if all rows in the result set are unique (distinct)
Format
UNIQUE ( query-expr )
Remarks
Used to test if every row in a result set is unique i.e. there are no duplicates.
Example:
SELECT A.NAME FROM A WHERE NOT UNIQUE ( SELECT B.DESC FROM B WHERE B.ID = A.ID )