Operators: EXISTS and IN
Learn how to check whether a query returns rows.
We'll cover the following...
We'll cover the following...
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 ...