Lim Seunghyun Space

[Leetcode] 196. Delete Duplicate Emails 본문

SQL/SQL 문제

[Leetcode] 196. Delete Duplicate Emails

Lim Seung Hyun 2022. 4. 18. 22:35

문제 출처

 

Delete 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

 

나의 풀이(MySQL)

DELETE P1 FROM Person AS P1
JOIN Person AS P2
ON P1.email = P2.email
WHERE P1.id > P2.id;
728x90
저작자표시

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

[Leetcode] Exchange Seats  (0) 2023.03.18
[Leetcode] 197. Rising Temperature  (0) 2022.04.18
[Leetcode] 184. Department Highest Salary  (0) 2022.03.25
[Leetcode] 183. Customers Who Never Order  (0) 2022.03.23
[Leetcode] 182. Duplicate Emails  (0) 2022.03.23
'SQL/SQL 문제' Related Articles more