Lim Seunghyun Space

[Leetcode] 182. Duplicate Emails 본문

SQL/SQL 문제

[Leetcode] 182. Duplicate Emails

Lim Seung Hyun 2022. 3. 23. 15:13

문제 출처

 

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

 

나의 풀이

select email as Email
from Person
group by email
having count(email) > 1;
728x90
저작자표시 (새창열림)

'SQL > SQL 문제' 카테고리의 다른 글

[Leetcode] 184. Department Highest Salary  (0) 2022.03.25
[Leetcode] 183. Customers Who Never Order  (0) 2022.03.23
[Leetcode] 181. Employees Earning More Than Their Managers  (0) 2022.03.23
[HackerRank] Type of Triangle  (0) 2021.11.30
[HackerRank] The PADS  (0) 2021.11.29
'SQL/SQL 문제' Related Articles more