Quantified Predicate Subqueries

Quantified predicate subqueries, which return a list of zero or more values, are subqueries in a where or having clause that are connected by any, all, in, or exists. The any or all subquery operators modify comparison operators.

There are three types of quantified predicate subqueries:

Although SAP ASE allows the keyword distinct in quantified predicate subqueries, it always processes the subquery as if distinct were not included.