[LeetCode] 196. Delete Duplicate Emails

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

DELETE p1
FROM Person AS p1
    LEFT JOIN Person AS p2 ON p1.email = p2.email
WHERE p1.id > p2.id