删除

编写一个 SQL 查询，来删除 Person 表中所有重复的电子邮箱，重复的邮箱里只保留 Id 最小 的那个。

delete p1
from Person as p1, 
     Person as p2
where
p1.Email=p2.Email 
and 
p1.Id>p2.Id; 

delete
from Person
where Id
not in 
(select need.Id  
from (
select min(Id) as Id 
from Person 
group by Email) as need)

再加一层 select 是因为 mysql中，不能先select一个表的记录，在按此条件进行更新和删除同一个表的记录。 所以 重新select一遍