Leetcode | 182. 查找重复的电子邮箱

182. 查找重复的电子邮箱

# Write your MySQL query statement below
select t.Email 
from (
    select Email, count(1) count_num 
    from Person 
    group by Email
) t 
where t.count_num > 1;