SQL ANY Keyword

The ANY keyword in SQL is used with a subquery (a query nested inside another query). It checks if *at least one* of the values returned by the subquery satisfies the condition in the main query.

ANY: Definition and Usage

ANY is particularly useful when you need to compare a value in your main query against multiple values retrieved from a subquery. If even a single value from the subquery meets the condition, the ANY operator returns TRUE for that row in the main query's result set.

Syntax


SELECT column_names
FROM table1
WHERE column_name = ANY (SELECT column_name FROM table2 WHERE condition);

Examples

Finding Products with Quantity 10

This query finds product names where the ProductID exists in the OrderDetails table with a Quantity of 10. If any order detail has a quantity of 10 for a product, that product's name will appear in the results.

Syntax


SELECT ProductName
FROM Products
WHERE ProductID = ANY (SELECT ProductID FROM OrderDetails WHERE Quantity = 10);

Output

This will list the names of products that have at least one order detail with a quantity of 10.


ProductName
------------
Product A
Product B

Finding Products with Quantity Greater Than 99

Similar to the above, but this checks for quantities greater than 99.

Syntax


SELECT ProductName
FROM Products
WHERE ProductID = ANY (SELECT ProductID FROM OrderDetails WHERE Quantity > 99);

Output

This lists the names of products with at least one order detail where the quantity exceeds 99.


ProductName
------------
Product X