LeetCode[MySQL] : Delete Duplicate Emails

SOOYEON·2022년 3월 18일
0

SQL

목록 보기
9/54

Delete Duplicate Emails

Q

DELETE p1 FROM Person p1,
    Person p2
WHERE
    p1.Email = p2.Email AND p1.Id > p2.Id

0개의 댓글