Quantified Comparison Predicates (ALL/ANY)

Snippet

Quantified Comparison Predicates (ALL/ANY)

The ALL predicate is an advanced SQL feature used to compare a value against every value returned by a subquery. In this case, it retrieves products that are more expensive than every single product in category 5, offering a more readable alternative to MAX() subqueries.

snippet.sql
sql
SELECT product_name, unit_price
FROM products
WHERE unit_price > ALL (
    SELECT unit_price 
    FROM products 
    WHERE category_id = 5
);

Breakdown

WHERE unit_price > ALL (...)

The condition evaluates to true only if the price is greater than every value in the set.

SELECT unit_price FROM products WHERE category_id = 5

The subquery defining the set of values for comparison.

Previous snippet Next snippet

From your library

Quantified Comparison Predicates (ALL/ANY)

Related