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

Submit a Comment

Your email address will not be published. Required fields are marked *

Footer Logo

Subscribe

Select Categories