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

2021-09-08 15:50:33 浏览数 (1)

代码语言:javascript复制
select Email from
(
  select Email, count(Email) as num
  from Person
  group by Email
) as statistic
where num > 1
;

解析:

代表

然后根据比较要判断那个

大于就输出就行了.

ode

0 人点赞