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
