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

 

posted on 2021-08-20 17:06  一仟零一夜丶  阅读(44)  评论(0)    收藏  举报