SQL Any Keyword
Table Of Contents:
- What Is SQL Any Keyword?
- Syntax Of SQL Any Keyword.
- Examples Of SQL Any Keyword.
(1) What Is SQL Any Keyword?
The
ANYoperator: returns a boolean value as a result.- The
ANYoperator: returns TRUE if ANY of the subquery values meet the condition
(2) Syntax Of SQL Any Keyword?
SELECT column_name(s)
FROM table_name
WHERE column_name operator ANY
(SELECT column_name
FROM table_name
WHERE condition);Note:
- The operator must be a standard comparison operator (=, <>, !=, >, >=, <, or <=).
(3) Examples Of SQL Any Keyword?
Product Table:
OrderDetails Table:
Example-1:
SELECT ProductName
FROM Products
WHERE ProductID = ANY (SELECT ProductID FROM OrderDetails WHERE Quantity = 10);
Example-2:
SELECT ProductName
FROM Products
WHERE ProductID = ANY (SELECT ProductID FROM OrderDetails WHERE Quantity > 1000);
Example-3:
SELECT * FROM employee WHERE salary > ANY (2000, 3000, 4000);