The SQL ANY Operator
The ANY operator is used to compare a value to every value returned by a subquery.
The ANY operator evaluates to TRUE if at least one value in the subquery result-set meet the condition.
ANY Syntax
SELECT
column_name(s)
FROM
table_name
WHERE
column_name operator
ANY (
subquery
);Note
The operator must be a standard comparison operator (=, <>, !=, >, >=, <, or <=).
Demo Database
Below is a selection from the "Products" table in the Northwind sample database:
| ProductID | ProductName | Price |
|---|---|---|
| 1 | Chais | 18.00 |
| 2 | Chang | 19.00 |
| 3 | Aniseed Syrup | 10.00 |
| 4 | Chef Anton's Cajun Seasoning | 22.00 |
And a selection from the "OrderDetails" table:
| OrderDetailID | ProductID | Quantity |
|---|---|---|
| 1 | 11 | 12 |
| 2 | 42 | 10 |
| 3 | 72 | 5 |
| 4 | 14 | 9 |