Solution#1
# Write your MySQL query statement belowDELETE p1FROM Person p1, Person p2 WHERE p1.Email = p2.EmailAND p1.Id > p2.IdSolution#2(更快)
# Write your MySQL query statement belowDELETE FROM Person WHERE Id NOT IN ( SELECT T.Id FROM ( SELECT MIN(Id) AS Id FROM Person GROUP BY Email ) T)新聞熱點
疑難解答
