Part 78: Set Difference with EXCEPT / MINUS

Returns all distinct rows found in Query 1 that do NOT appear in Query 2.

1. Syntax

-- Customers who have never signed up for the newsletter:
SELECT email FROM customers
EXCEPT -- (Used as MINUS in Oracle)
SELECT email FROM newsletter_subscribers;

Key Takeaways

• EXCEPT finds records present in the first query but absent in the second.

In Part 79, we explore Set Intersection with INTERSECT!