【LeetCode】182.寻找重复的电子邮箱


select Email from
(
select Email, count(Email) as num
from Person
group by Email
) as statistic
where num > 1
;
解析:
代表

然后根据比较要判断那个
大于就输出就行了.


select Email from
(
select Email, count(Email) as num
from Person
group by Email
) as statistic
where num > 1
;
解析:
代表

然后根据比较要判断那个
大于就输出就行了.