|
The syntax for the EXISTS search condition is as follows:
EXISTS( subquery )
The EXISTS search 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 search condition cannot be UNKNOWN.