SQL EXISTS Operator

The EXISTS Operator in SQL is used to check the availability of the record in the correlated nested query. It checks whether the result generated in the nested query is empty or not.

The result of EXISTS is the BOOLEAN VALE that true or false. The operator can be used with statements such as SELECT, UPDATE, INSERT, etc.

• Syntax of EXISTS Operator –

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


Consider the Product table and the Manager’s table from the Customer database.

Demo table –

Product Table –

Manager’s table – 

Example – Using the EXISTS operator, retrieve the CustomerID and CustomerName if the Region of both the tables matches.

SELECT [Customer ID],[Customer Name] FROM [dbo].[Products]
WHERE EXISTS
(SELECT * FROM [dbo].[Manager]
WHERE [dbo].[Products].Region = [dbo].[Manager].Region );


The output after implementing the above EXISTS, operator –

• The correlated nested subquery in the example returns “TRUE”, then we have the output for the result.

Other SQL topics to check out:

• What is RDBMS (Relational Database Management System)?
• SQL SELECT Statement
• SQL INSERT INTO SELECT Statement
• SQL ALL Operator
• SQL WHERE Clause
• SQL AND Operator
• SQL OR Operator

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