196. 删除重复的电子邮箱

196. 删除重复的电子邮箱

---

题目链接：196. 删除重复的电子邮箱

代码如下：

# Write your MySQL query statement below
delete 
from Person as p
where p.id not in(
    select e.id from (
        select min(id) as id
        from Person 
        group by email ) as e
)