반응형
https://leetcode.com/problems/duplicate-emails/description/
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
group by를 사용해본 문제였습니다.
📕 풀이방법
📔 풀이과정
집계함수를 쓰기 위해 group by를 사용했습니다. having으로 email에 대한 count가 1초과시 중복되었으므로 해당 email들을 select해줍니다.
📕 Code
📔 MySQL
select email as Email
from Person
group by email
having count(email) > 1*더 나은 내용을 위한 지적, 조언은 언제나 환영합니다.
'SQL' 카테고리의 다른 글
| (MySQL) - LeetCode (medium) 176. Second Highest Salary (0) | 2022.12.20 |
|---|---|
| (MySQL) - LeetCode (easy) 182. Duplicate Emails (0) | 2022.12.15 |
| (MySQL) - LeetCode (easy) 181. Employees Earning More Than Their Managers (0) | 2022.12.13 |
| (MySQL) - LeetCode (easy) 175. Combine Two Tables (0) | 2022.12.12 |
| (MySQL Workbench) - MySQL version sql로 확인 (0) | 2021.12.09 |
