Lesson 8.3 · Pro
Find and remove duplicates
Spot duplicate rows, then keep just one per group, usually the newest.
In this lesson
- Find duplicates with GROUP BY and HAVING
- Keep one row per group with DISTINCT ON
- Remove repeats before you count
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.