196. Delete Duplicate Emails

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

Delete Duplicate Emails - LeetCode

delete a from Person a, Person b
where a.id > b.id and a.email = b.email;

 

best

DELETE FROM Person WHERE Id NOT IN 
(SELECT * FROM(
    SELECT MIN(Id) FROM Person GROUP BY Email) as p);

 

References

https://iwordpower.com/how-to-delete-duplicate-records-in-mysql/