Compares a scalar value with a single-column set of values.
scalar_expression { = | <> | != | > | >= | !> | < | <= | !< } ALL (subquery)
Is a restricted SELECT statement (the ORDER BY clause, the COMPUTE clause, and the INTO keyword are not allowed).
Boolean
Returns TRUE when the comparison specified is TRUE for all pairs (scalar_expression, x) where x is a value in the single-column set; otherwise returns FALSE.
CASE | Operators (Logical Operators) |
Expressions | SELECT (Subqueries) |
Functions | WHERE |
LIKE |