196. Delete Duplicate Emails#1

Solution#1

# Write your MySQL query statement below
DELETE p1
FROM Person p1, Person p2 
WHERE p1.Email = p2.Email
AND p1.Id > p2.Id

Solution#2(更快)

# Write your MySQL query statement below
DELETE FROM Person WHERE Id NOT IN (
    SELECT T.Id FROM (
        SELECT MIN(Id) AS Id FROM Person GROUP BY Email
    ) T
)