https://leetcode-cn.com/problems/delete-duplicate-emails/description/
删除p1表,p1 和 p2 表的 Email 相等并且 p1 表的 Id 比 p2 表的 Id 大
delete p1
from Person p1,Person p2
where p1.Email = p2.Email
and p1.Id > p2.Id;
https://leetcode-cn.com/problems/delete-duplicate-emails/description/
删除p1表,p1 和 p2 表的 Email 相等并且 p1 表的 Id 比 p2 表的 Id 大
delete p1
from Person p1,Person p2
where p1.Email = p2.Email
and p1.Id > p2.Id;