Skip to content

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
  )