Operators: EXISTS and IN

Learn how to check whether a query returns rows.

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.

Get hands-on with 1200+ tech skills courses.