【LeetCode】196. Delete Duplicate Emails

题目要求：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 p1
FROM Person AS p1, Person AS p2
WHERE p1.Email = p2.Email AND p1.Id > p2.Id