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