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.IdSolution#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 )