EXISTS predicate

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

The EXISTS predicate tests for the existence of certain rows. 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)