https://leetcode-cn.com/problems/duplicate-emails/description/
直接group by分组然后count统计得到结果
select Email from Person group by Email having count(*) > 1;
https://leetcode-cn.com/problems/duplicate-emails/description/
直接group by分组然后count统计得到结果
select Email from Person group by Email having count(*) > 1;