182. 查找重复的电子邮箱
# Write your MySQL query statement below SELECT Email FROM #获取Email个数的表 (SELECT Email,COUNT(Email) AS c FROM Person GROUP BY Email) as e WHERE e.c>1
# Write your MySQL query statement below SELECT Email FROM #获取Email个数的表 (SELECT Email,COUNT(Email) AS c FROM Person GROUP BY Email) as e WHERE e.c>1