Contents Index IN conditions IS NULL conditions

ASA SQL Reference
  SQL Language Elements
    Search conditions

EXISTS conditions


The syntax for EXISTS conditions is as follows:

EXISTS( subquery )

The EXISTS condition is TRUE if the subquery result contains at least one row, and FALSE if the subquery result does not contain any rows. The EXISTS condition cannot be UNKNOWN.

Standards and compatibility 

Contents Index IN conditions IS NULL conditions