[리트코드/SQL] 30. Duplicate Emalis (182)

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

Duplicate Emails - LeetCode

---

🤔 문제 분석

1) Write an SQL query to report all the duplicate emails.

2) Return the result table in any order.

 

💡 풀이

select Email
FROM Person
group by Email
having count(*) > 1