问题描述
https://leetcode.com/problems/delete-duplicate-emails/
代码
# Write your MySQL query statement below
DELETE p1
FROM Person as p1, Person as p2
WHERE p1.Email = p2.Email AND p1.Id > p2.Id;
https://leetcode.com/problems/delete-duplicate-emails/
# Write your MySQL query statement below
DELETE p1
FROM Person as p1, Person as p2
WHERE p1.Email = p2.Email AND p1.Id > p2.Id;
