T-SQL - ANY Keyword

The T-SQL (Transact-SQL) ANY keyword is used with WHERE and HAVING clause. It returns TRUE if any of the subquery values satisfies the condition.

Syntax

The syntax for using ANY keyword in T-SQL (Transact-SQL) is given below:

SELECT column1, column2, column3, ...
FROM table_name
WHERE column_name operator ANY
(SELECT column1, column2, ... 
FROM table_name WHERE condition);

Example:

Consider a database containing tables called Employee and Contact_Info with the following records:

Table 2: Contact_Info table

• To select records of male employees from Employee table, the query is given below.

  SELECT * FROM Employee
  WHERE EmpID = ANY
  (SELECT EmpID 
  FROM Contact_Info WHERE Gender = 'M');
  

  
  

  The subquery will produce following result:

  EmpID
  3
  6
  7
  8

  The query then compares EmpID values with subquery result. It returns TRUE as few records satisfy the condition and produces the following result:

  EmpID	Name	City	Age	Salary
  3	Jo	Paris	27	2800
  6	Huang	Beijing	28	2800