SQL ANY Operator

The ANY Operator is used in SQL to compare values with single columns and the range of values. The statement returns to be “TRUE” if any of the values are true in the range. The ANY Operator returns boolean values as its result.

• Syntax of ANY Operator – 

SELECT column1,column2,column3,...,columnN FROM table_name
WHERE column1,column2
OPERATOR ANY
(SELECT column1,column2,column3,...,columnN
FROM table_name
WHERE condition );


Demo Table – 

Product Table –

Manager’s Table – 

Example – Consider the above table Product & Manager Tables and retrieve CustomerName using the ANY Operator whose Region is “Central”.

SELECT [Customer Name] , Region
FROM [dbo].[Products]
WHERE [Region] = ANY
(SELECT [Region] FROM [dbo].[Manager] WHERE Region = 'Central');


The output after implementing the above ANY operator  –

Follow us on Twitter, Facebook, Linkedin, and Tableau Public to stay updated with our latest blog, Job Openings, Internships, and what’s new in Tableau.

Other SQL topics to check out:

• How to write SQL Select Statements
• Introduction to SQL for Data Scientists
• What is RDBMS (Relational Database Management System)?
• SQL WHERE Clause

Follow us on Twitter, Facebook, Linkedin, and Tableau Public to stay updated with our latest blog and what’s new in Tableau.

If you are looking forward to getting your data pipeline built and setting up the dashboard for business intelligence, book a call now from here.

#analytics #data #business #artificialintelligence #machinelearning #startup #deeplearning #deeplearning #datascience #ai #growth #dataanalytics #india #datascientist #powerbi #dataanalysis #tableau #SQL #businessanalytics #businessanalyst #businessandmanagement #dataanalyst #businessanalysis #analyst #analysis #powerbideveloper #powerbidesktop #letsviz