[LeetCode] 182. Duplicate Emails

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

WITH duplicate_nums AS (
    SELECT email
         , COUNT(DISTINCT id) AS duplicate_num
    FROM Person
    GROUP BY email
)

SELECT email AS Email
FROM duplicate_nums
WHERE duplicate_num > 1