리트코드(LeetCode) SQL 문제풀이 - 182. Duplicate Emails

MySQL 문제 182. Duplicate Emails

MySQL 코드 답

select email from
(
    select email,COUNT(email) as num
        from Person
        group by email
) as tmp
where num>1;