Show TOC

Background documentationEXISTS Predicate (exists_predicate)

 

The EXISTS predicate (exists_predicate) is a predicate that checks whether a result table contains at least one row.

Structure

Syntax Syntax

  1. <exists_predicate> ::=
  EXISTS <subquery>
End of the code.
Examples

SQL Tutorial, Subquery: Inner Queries

Explanation

The truth content of an EXISTS predicate is either true or false.

The subquery generates a result table. If this result table contains at least one row, EXISTS <subquery> is true.