SQL - ANY Operator

The SQL ANY Operator 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 operator 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 SQL code 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 SQL 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