ALL
conditional expression is a predicate that is true
if the comparison operation is true
for all values in the result of the subquery or the result of the subquery is empty. An ALL
conditional expression is false
if the result of the comparison is false
for at least one row, and is unknown if neither true
nor false
. An ANY
conditional expression is a predicate that is true
if the comparison operation is true
for some value in the result of the subquery. An ANY
conditional expression is false
if the result of the subquery is empty or if the comparison operation is false
for every value in the esult of the subquery, and is unknown if neither true
nor false
. The keyword SOME
is synonymous with ANY
. The comparison operators used with ALL
or ANY
conditional expressions are =, <, <=,>, >=, <>. The result of the subquery must be like that of the other argument to the comparison operator in type.
all_or_any_expression ::= {ALL|ANY|SOME}(subquery)
@see AllOrAnyExpression @version 2.4 @since 2.4 @author Pascal Filion
|
|
|
|