select Email from ( select Email, count(Email) as num from Person group by Email ) as statistic where num > 1 ;
解析：
代表
然后根据比较要判断那个
大于就输出就行了.
【LeetCode】182.寻找重复的电子邮箱
关注
打赏
select Email from ( select Email, count(Email) as num from Person group by Email ) as statistic where num > 1 ;
解析：代表
然后根据比较要判断那个大于就输出就行了.
微信扫码登录