ANY and ALL

Compare against a subquery with ANY and ALL.

ANY compares against any value in the list, ALL against every value.

SELECT name FROM products
WHERE price > ANY (SELECT price FROM products WHERE category = 'Kitap');

This query returns products more expensive than any book.

name is selected from products. WHERE keeps only the rows where price > ANY (SELECT price FROM products WHERE category = … holds.

ANY and ALL — details

ANY means 'at least one', ALL means 'every'. They work with the list from the subquery.

For example, price > ALL (…) returns values greater than the largest in the list, while price > ANY (…) returns those greater than the smallest.

Find products more expensive than any book using > ANY (SELECT price ...).

Show example solution

SELECT name FROM products
WHERE price > ANY (SELECT price FROM products WHERE category = 'Kitap');

Add ANY

SELECT name FROM products
WHERE price > ____ (SELECT price FROM products WHERE category = 'Kitap');

Show answer

SELECT name FROM products
WHERE price > ANY (SELECT price FROM products WHERE category = 'Kitap');