182. 查找重复的电子邮箱

182. 查找重复的电子邮箱

使用 having

select Email
from Person 
group by Email 
having count(Email) > 1;

使用子表

select Email from 
(select Email, count(Email) as count 
from Person
group by Email) as t
where t.count > 1;