196. Delete Duplicate Emails
# Write your MySQL query statement below
DELETE p2 FROM Person p1 JOIN Person p2
ON p2.Email = p1.Email WHERE p2.Id > p1.Id;
https://github.com/qixing810/leetcode_database
# Write your MySQL query statement below
DELETE p2 FROM Person p1 JOIN Person p2
ON p2.Email = p1.Email WHERE p2.Id > p1.Id;