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.
MySQL SQL
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.