题目要求:Write a SQL query to delete all duplicate email entries in a table named Person
, keeping only unique emails based on its smallest Id.
解答:
# Write your MySQL query statement below
DELETE p1FROM Person AS p1, Person AS p2
WHERE p1.Email = p2.Email AND p1.Id > p2.Id