Part 79: Set Intersection with INTERSECT

Returns only rows that exist in both result sets.

1. Syntax

-- Customers who are also suppliers:
SELECT email FROM customers
INTERSECT
SELECT email FROM suppliers;

Key Takeaways

• INTERSECT finds common records between queries.

In Part 80, we explore Refactoring Complex Nested Subqueries for Performance!