参考评论区解答:
delete t1 from person t1,person t2 where t1.email=t2.email and t1.id>t2.id
leetcode sql No.196 删除重复的电子邮箱
最新推荐文章于 2022-08-12 21:45:05 发布
参考评论区解答:
delete t1 from person t1,person t2 where t1.email=t2.email and t1.id>t2.id