196. Delete Duplicate Emails

https://leetcode.com/problems/delete-duplicate-emails

MySQL

DELETE FROM Person
WHERE id NOT IN
( SELECT min_id FROM (
        SELECT MIN(id) AS min_id, email
        FROM Person
        GROUP BY email
    ) sub
)