sql any
Returns true if any of the subquery values meet the given condition. Example: Returns products from the products table which have received orders – stored in the orders table – with a quantity of more than 5. SELECT name FROM products WHERE productId = ANY (SELECT productId FROM orders WHERE quantity > 5);