[Leetcode] 196. Delete Duplicate Emails

SQL/SQL 문제

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