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;

posted @ 2018-12-22 03:49  yuesi  阅读(123)  评论(0编辑  收藏  举报