leetcode（182） 查找重复的电子邮箱

方法一：
HAVING+COUNT

# Write your MySQL query statement below
SELECT DISTINCT Email
FROM Person
GROUP BY Email
HAVING COUNT(Email)>1
;

方法二：
使用 GROUP BY 和临时表

# Write your MySQL query statement below
SELECT Email
FROM
(
    SELECT Email,COUNT(Email)AS num
    FROM Person
    GROUP BY Email
)AS temp
WHERE num>1
;

方法三：
内连接：

# Write your MySQL query statement below
SELECT DISTINCT P1.Email AS Email
FROM Person P1,Person P2
WHERE P1.Email=P2.Email AND 
      P1.Id!=P2.Id 
;