182. 查找重复的电子邮箱

题意

题目链接

思路

通过子查询，来弄

代码

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