求重复的邮箱

id email
1 a@b.com
2 c@b.com
3 a@b.com
求重复的电子邮箱
select email
from(
select email,count(email) as email_count
from person
group by email ) as e
where email_count>1;