Supported SQL Statements and Extensions for the Salesforce Driver
:
Subqueries
:
UNIQUE Predicate
UNIQUE Predicate
Purpose
Determines 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)