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 –

Category Region City Country Customer_ID Customer_name
Office Supplies Central Chicago United States SM-20950 Suzanne McNair
Technology East New York City United States AH-10465 Amy Hunt
Office Supplies East New York City United States AH-10465 Amy Hunt
Office Supplies East Dover United States EP-13915 Emily Phan
Office Supplies East Dover United States EP-13915 Emily Phan
Technology West Aurora United States TP-21565 Tracy Poddar
Office Supplies West Aurora United States TP-21565 Tracy Poddar
Office Supplies East Long Beach United States AR-10825 Anthony Rawles
Office Supplies West Pasadena United States HA-14920 Helen Andreada
Furniture West Pasadena United States HA-14920 Helen Andreada

 

Manager’s Table – 

Region Regional Manager
West Sadie Pawthorne
East Chuck Magee
Central Roxanne Rodriguez
South Fred Suzuki

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  –

Customer_name Region
Suzanne McNair Central

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:

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

Automate data analysis pipeline and create report ready dashboards

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