Operator EXISTS

The EXISTS operator is used to test the existence of a given record in a subquery. The EXISTS operator returns TRUE if one or more records are found in the subquery.

Formula:

SELECT column1
, column2
, column3
FROM Table1
WHERE EXISTS
(SELECT column4 FROM Table2 WHERE condition1);

Interesting article? Share further!

Leave A Comment