Quantified Comparisons for Global Set Constraints

Snippet

Quantified Comparisons for Global Set Constraints

The ALL predicate is an ANSI SQL quantified comparison that evaluates to true only if the comparison holds for every row in the subquery result set. It provides a more readable and declarative alternative to MAX() comparisons when dealing with correlated subqueries or empty sets.

snippet.sql
sql
SELECT account_id, balance
FROM ledger
WHERE balance > ALL (
  SELECT balance 
  FROM risk_thresholds 
  WHERE category = 'EXTREME'
);

Breakdown

WHERE balance > ALL

Specifies that the balance must be greater than every single value returned by the following set.

SELECT balance FROM risk_thresholds

The subquery defining the set of values for the universal quantification.

Previous snippet Next snippet

From your library

Quantified Comparisons for Global Set Constraints

Related