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 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:
expression = ANY ( 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.
You can use the keyword SOME instead of ANY.
The syntax for ALL conditions is:
expression compare ALL ( subquery )
where compare is a comparison operator.
If there is more than one expression on either side of a quantified comparison predicate, an error message is returned. For example:
Subquery allowed only one select list item
Queries of this type can always be expressed in terms of IN subqueries or scalar subqueries using MIN and MAX set functions.
ANY and ALL subqueries are compatible between Adaptive Server Enterprise and Sybase IQ. Only Sybase IQ supports SOME as a synonym for ANY.
