Mysql中的临时表必须命名
力扣182. 查找重复的电子邮箱
select Email from
(
select Email, count(Email) as num
from Person
group by Email
) as statistic
where num > 1
;
其中的as statistic为表命名
Mysql中的临时表必须命名
力扣182. 查找重复的电子邮箱
select Email from
(
select Email, count(Email) as num
from Person
group by Email
) as statistic
where num > 1
;
其中的as statistic为表命名