https://leetcode.com/problems/duplicate-emails/description/
👇 정답 코드
SELECT Email
FROM Person
GROUP BY Email
HAVING COUNT(id) > 1
'Algorithm & SQL > LeetCode' 카테고리의 다른 글
| [LeetCode 181번 / MySQL] 181 : Employees Earning More Than Their Managers (0) | 2024.03.10 |
|---|---|
| [LeetCode 183번 / MySQL] 183 : Customers Who Never Order (0) | 2024.03.10 |
| [LeetCode 1179번 / MySQL] 1179 : Reformat Department Table (0) | 2024.03.10 |
| [LeetCode 595번 / MySQL] 595 : Big Countries (0) | 2024.03.10 |
| [LeetCode 620번 / MySQL] 620 : Not Boring Movies (0) | 2024.03.10 |
