Contents Index Subqueries in search conditions BETWEEN conditions

ASA SQL Reference
  SQL Language Elements
    Search conditions

ALL or ANY conditions


The syntax for ANY conditions is

expression compare ANY ( subquery )

where compare is a comparison operator.

For example, an ANY condition with an equality operator,

expression = ANY ( subquery )

is TRUE if expression is equal to any of the values in the result of the subquery, and FALSE if the expression is not NULL and does not equal any of the columns of the subquery. The ANY condition is UNKNOWN if expression is the NULL value, unless the result of the subquery has no rows, in which case the condition is always FALSE.

The keyword SOME can be used instead of ANY.

The syntax for ALL conditions is

expression compare  ALL ( subquery )

where compare is a comparison operator.

Standards and compatibility 

Contents Index Subqueries in search conditions BETWEEN conditions