做网站的分页查询,建设网站的网站空间,宣传方式,上海做网站优化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 idfrom Person group by email ) as e
)
196. 删除重复的电子邮箱
题目链接：196. 删除重复的电子邮箱
代码如下：
#Write your MySQL query statement belowdelete
from Person as p
where p.id notin(select e.id from(select min(id) as idfrom Person group by email ) as e
)
