196. Delete Duplicate Emails

https://leetcode.com/problems/delete-duplicate-emails/

SQL

delete p1 from Person p1, Person p2 where p1.Email=p2.Email and p1.id>p2.Id