Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Language Elements : Data types : Relational operators : Quantified Predicate : EXISTS Predicate
EXISTS Predicate
The EXISTS predicate can be used to check for the existence of specific rows. The query_expression returns rows rather than values. The predicate evaluates to true if the number of rows returned by the query_expression is nonzero.


This is the syntax for an EXISTS predicate:
EXISTS (query_expression)


In this example, the predicate returns the item names of all items which contain sub-items:
SELECT itemname FROM pub.mtitem
  WHERE EXISTS(SELECT subitem FROM pub.mtitem);