Find duplicate records

Find customers with duplicate email addresses, then show how to keep only the most recent.

Setup & sample data

The playground will create these tables and populate them automatically when you click "Open Playground" above:

Solutions

Multiple approaches — try each and understand the trade-offs.

Expected output