EXISTS

An operator that is true when a subquery returns at least one row, whatever the row contains.

In more detail

It stops looking at the first match, so it is cheap. NOT EXISTS is the safe way to ask for rows with no match, because unlike NOT IN it is not confused by NULLs.

Related terms

Taught in

References