MySQL SQL
MySQL ANY
Compare a value with one or more values returned by a subquery.
SELECT * FROM products
WHERE price > ANY (SELECT price FROM clearance_products);The comparison is true if it succeeds for at least one subquery value.
MySQL SQL
Compare a value with one or more values returned by a subquery.
SELECT * FROM products
WHERE price > ANY (SELECT price FROM clearance_products);The comparison is true if it succeeds for at least one subquery value.