通过单个字段(name)删除:delete from user where id not in
(
select id from
(
select max(id) id from user group by name
) a
);
通过多个字段(name,age)删除:delete from user where id not in
(
select id from
(
select max(id) id from user group by name,age
) a
);
其实差不多啦,不过这么写sql效率很低,欢迎大家有什么高效的写法教给我,谢谢啦!
mysql删除数据库表中重复数据(根据单个或多个字段)
最新推荐文章于 2024-04-16 13:41:20 发布