Lesson 8.2 · Pro
INTERSECT and EXCEPT
Find rows that appear in both results, or in one but not the other.
In this lesson
- INTERSECT: in both results
- EXCEPT: in the first but not the second
- The same with conditional counts
Go Pro to read this lesson
Pro unlocks every lesson and practice problem in SQL, Python, pandas and NumPy, with answers and step-by-step explanations.