Operators: EXISTS and IN

The EXISTS operator lets us check whether a subquery returns any rows. Because no rows are yielded by the subquery as an output when EXISTS is used, we can expect a faster subquery performance. There is also the IN operator, which lets us check whether a value exists in a given range.

For our examples, we’ll use the tables in the Match database.

The EXISTS operator

There are two ways of using the EXISTS operator. We can check to ...