-- @Title: 删除重复的电子邮箱 (Delete Duplicate Emails)
-- @Author: 15816537946@163.com
-- @Date: 2021-03-03 14:44:23
-- @Runtime: 1696 ms
-- @Memory: 0 B
# Write your MySQL query statement below
delete p1
from Person p1, Person p2
where p1.Email = p2.Email and p1.Id > p2.Id
|