How To Use Exists Operator In SQL

In this article, we will learn how to use the EXISTS operator in SQL.

The EXISTS operator is used to checking the presence of any record in a subquery.

If the subquery returns one or more records, the EXISTS operator returns true.

Syntax

SELECT column_name(s)
FROM TABLE_NAME1 
WHERE EXISTS
(SELECT column_name FROM TABLE_NAME2 WHERE condition);

Example

The subsequent statement would return TRUE and lists the technologies with an article views more than 100:

SELECT *
FROM Technology
WHERE EXISTS (SELECT Name FROM Article WHERE Views > 100);

Also, check How To Use HAVING Clause In SQL

Yasin Panwala

Yasin Panwala is a Web Developer and Author at TheCodeHubs. He has experience in Web Developing and Designing and also in Writing. He has got his skills in working on technologies like .NET Core, ADO.NET, AJAX, Angular, AngularJS, ASP.NET, ASP.NET MVC, Bootstrap, C#, CSS, Entity Framework, Express.js, GraphQL, HTML, JavaScript, JQuery, JSON, LINQ, Microsoft Office, MongoDB, MySQL, Node.js, PostgreSQL, SQL, SQL Server, TypeORM, TypeScript, Visual Basic .NET, Web API. He also got his skills in working with different integration and some known versioning tools. He is always ready to learn new things and he always tries his best on tasks that are assigned to him and gives the best possible outputs.