[182\. 查找重复的电子邮箱](https://leetcode-cn.com/problems/duplicate-emails/)
===
### 今天面试遇到这个问题,恨啊!没有作这一到题 哭
### 解题 方法一
`SELECT Email from Person GROUP BY Email having count(Email)>1`
### 解题 方法二
```
SELECT Email from
(
SELECT Email,count(Email) AS num
FROM Person
GROUP BY Email
) as ns
where num > 1;
```
