picoSQL - Language reference manual

6.6) EXISTS predicate

This predicate allows to verify the existence at least a rows in any table that satisfies some conditions. The syntax is:

EXISTS (subquery)

The result of predicate is TRUE if the subquery result contains at least one row, FALSE otherwise.