LeetCode Delete Duplicate Emails [ MySQL ]

Delete Duplicate Emails - LeetCode

 

서브쿼리

 

DELETE

FROM
    person
WHERE
    id NOT IN (
        SELECT
            id
        FROM (
            SELECT
                email,
                MIN(id) as id
            FROM
                person
            GROUP BY 1
        ) temp
    )

 

조인

DELETE
    p1
FROM
    person p1
INNER JOIN
    person p2 on p1.email = p2.email
WHERE
    p1.id > p2.id