SQL/SQL 문제풀이

[SQL] LeetCode SQL 182. Duplicate Emails

웅겹사r☆ 2021. 11. 29. 00:13

 

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

 

Duplicate Emails - LeetCode

Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.

leetcode.com

LeetCode SQL문제풀이 시작

 

 

문제는 심플하다

중복된 이메일이 1개 초과인 이메일을 뽑아내면된다.

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

 

심플!!