过滤出重复的邮件

#select email from (select email, count(*) as sum from Person group by email) tmp where tmp.sum >= 2;
#以邮件字段进行分组，然后用having进行过滤
select Email
from Person
group by Email
having count(Email) > 1;