Return rows present in both queries.
Section: EXISTS and Set Operations
Find common rows with INTERSECT
sql
sql
SELECT user_id FROM newsletter_subscribers
INTERSECT
SELECT user_id FROM paying_customers;Explanation
INTERSECT behaves like set intersection in SQL dialects that support it.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing EXISTS and Set Operations
Combine result sets with UNION
Merge distinct rows from two compatible queries.
Subtract rows with EXCEPT
Return rows from the first query not present in the second.