Leetcode_182_查找重复的电子邮箱_SQL

select email
from person
group by email
having count(email) > 1

# Write your MySQL query statement below
select email
from (
    select email, count(email) as cnt
    from person
    group by email
) as t
where cnt > 1