delete p1 //DELETE p1就表示从p1表中删除满足WHERE条件的记录。
from Person p1,Person p2
where p1.Email=p2.Email and p1.Id>p2.Id;
LeetCode-SQL-196. 删除重复的电子邮箱-easy
最新推荐文章于 2024-06-07 14:16:07 发布
delete p1 //DELETE p1就表示从p1表中删除满足WHERE条件的记录。
from Person p1,Person p2
where p1.Email=p2.Email and p1.Id>p2.Id;