MySQL SQL

MySQL ALL

Compare a value with every value returned by a subquery.

SELECT * FROM products
WHERE price > ALL (SELECT price FROM clearance_products);

The comparison is true only when it succeeds for every returned value.