leetcode查询重复的电子邮箱

SQL架构：

Create table If Not Exists Person (Id int, Email varchar(255))
Truncate table Person
insert into Person (Id, Email) values ('1', 'a@b.com')
insert into Person (Id, Email) values ('2', 'c@d.com')
insert into Person (Id, Email) values ('3', 'a@b.com')

方法一：使用group by和临时表

select Email from (select Email, count(Email) as num from Person
group by Email) as statistic
where num > 1

方法二：使用group by和having条件

# Write your MySQL query statement below
select Email from Person
group by Email
having count(Email) > 1