EXISTS predicate

The EXISTS predicate tests for the existence of certain rows.

Read syntax diagramSkip visual syntax diagram
>>-EXISTS--( fullselect )--------------------------------------><

The fullselect may specify any number of columns, and

The values returned by the fullselect are ignored.

Example

   EXISTS (SELECT * 
            FROM EMPLOYEE WHERE SALARY > 60000)