自连接
delete a from person as a join person as b
where a.email = b.email and a.id > b.id
LeetCode_MySQL06_196删除重复的电子邮箱
最新推荐文章于 2024-07-10 11:04:17 发布
自连接
delete a from person as a join person as b
where a.email = b.email and a.id > b.id