[LeetCode] 182. Duplicate Emails

문제

Write a solution to report all the duplicate emails. Note that it's guaranteed that the email field is not NULL.

Return the result table in any order.

The result format is in the following example.

 

중복되는 이메일이 있으면 해당 이메일을 출력하도록 해야한다.

 

쿼리

SELECT 
    EMAIL
FROM 
    PERSON
GROUP BY 
    EMAIL
HAVING 
    COUNT(EMAIL) > 1;

 

 

 

 

문제 출처

https://leetcode.com/problems/duplicate-emails/description/