select Email from
(
select Email, count(Email) as num
from Person
group by Email
) as statistic
where num > 1
;
LeetCode-182-Duplicate Emails-E(SQL语句)
最新推荐文章于 2024-09-29 20:28:48 发布
select Email from
(
select Email, count(Email) as num
from Person
group by Email
) as statistic
where num > 1
;