ALL
| <field_expr> <rel_op> ALL ( <value_rows> ) |
| ( <field_expr_list> ) <rel_op> ALL ( <value_rows> ) |
The ALL operator compares a given field-expression with a list of values,
returning TRUE if all values in the list satisfy the comparison operation, or FALSE if not
all values satisfy the comparison.
Examples
A. Single field-expression
The following example expression determines whether or not the "Year" field is greater than all the values in the specified list:Year > ALL (1999; 2000; 2001)B. List of field-expressions
The following example expression determines whether or not the pair of "Year" and "Age" fields is less than all the pairs of values in the specified list:(Year, Age) < ALL (1999, 30; 2001, 40; 2002, 10)
See also:
ANYExpressions
Field-Expressions