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-09-14 19:00:09 发布
delete p1 //DELETE p1就表示从p1表中删除满足WHERE条件的记录。
from Person p1,Person p2
where p1.Email=p2.Email and p1.Id>p2.Id;