How to Use ANY Keyword in SQL

The ANY operator compares a value to any one of the values returned by a subquery. It returns TRUE if the comparison is true for at least one value in the subquery result.

Syntax:

expression operator ANY (subquery)

• operator can be: =, !=, <, >, <=, >=

• subquery returns a list of values.

How ANY Works:

• value > ANY (subquery) means value is greater than at least one value in the subquery.

• value < ANY (subquery) means value is less than at least one value in the subquery.

Example:

Suppose a table products with columns: product_id, price.

Find products priced less than any product in category 2 (i.e., cheaper than at least one product in category 2):

SELECT *FROM productsWHERE price < ANY (    SELECT price FROM products WHERE category_id = 2);

Important Notes:

• If the subquery returns no rows, the condition evaluates to FALSE.

• ANY is often used interchangeably with SOME (both work the same).

• It is useful when you want to check if a value matches or compares with at least one value from a set.

If you want me to explain with more examples or a particular operator, just say!