Check whether elements in multiple columns meet a condition
Use the ANY or SOME function to check whether at least one element in multiple columns meets a condition. Use the ALL function to check whether all elements in multiple columns meet a condition.
SQL
* |
SELECT
1 < ANY (
VALUES
1,
2,
3,
4
),
20 < ALL (
VALUES
19,
20,
21
),
20 < SOME (
VALUES
19,
20,
21
)