Multiple EXISTS

Combine several EXISTS with AND/OR.

Multiple EXISTS

You can combine multiple EXISTS clauses with AND and OR.

SELECT name FROM customers c
WHERE EXISTS (SELECT 1 FROM orders o WHERE o.customer_id = c.id)
  AND EXISTS (SELECT 1 FROM reviews r WHERE r.customer_id = c.id);

This query returns those with both orders and reviews.

name is selected from customers c. WHERE keeps only the rows where EXISTS (SELECT 1 FROM orders o WHERE o.customer_id = c.id) … holds.

Multiple EXISTS — details

Each EXISTS is a separate subquery. AND requires both, OR at least one.

For example, you find customers with both an order and a review using AND, and those with either one using OR.

Exercise Multiple EXISTS

Find customers with both orders and reviews using two EXISTS and AND.

Show example solution

SELECT name FROM customers c
WHERE EXISTS (SELECT 1 FROM orders o WHERE o.customer_id = c.id)
  AND EXISTS (SELECT 1 FROM reviews r WHERE r.customer_id = c.id);

Test yourself

Add AND

WHERE EXISTS (SELECT 1 FROM orders o WHERE o.customer_id = c.id)
  ____ EXISTS (SELECT 1 FROM reviews r WHERE r.customer_id = c.id);

Show answer

WHERE EXISTS (SELECT 1 FROM orders o WHERE o.customer_id = c.id)
  AND EXISTS (SELECT 1 FROM reviews r WHERE r.customer_id = c.id);

Multiple EXISTS: match the terms

AND

both
OR

at least one
EXISTS

existence
NOT

not
What does AND with two EXISTS require?
- Only the first
- Only one of them
- None
- Both of them
Show answer

Both of them — AND requires both EXISTS to be true.

Next lesson: Summary - EXISTS

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies