1.查找表中多余的重复记录,重复记录是根据单个字段(name)来判断 select * from libwhere name in (select name from lib group by name ha
select * from libwhere name in (select name from lib group by name having count(name) > 1)
delete from libwhere name in (select name from (select name from lib group by name having count(name) > 1) as a)and id not in (select min_id from (select min(id) as min_id from lib group by name having count(name)>1) as b)
DELETE FROM lib WHERE (`name`, version) IN (SELECT t.`name`, t.version FROM (SELECT `name`, version FROM lib GROUP BY `name`, version HAVING count(1) > 1 ) t)AND id NOT IN ( SELECT dt.minid FROM (SELECT min(id) AS minid FROM lib GROUP BY `name`, version HAVING count(1) > 1 ) dt);
参考:https://blog.csdn.net/JineD/article/details/126875291
来源地址:https://blog.csdn.net/qq_45058475/article/details/128597176
--结束END--
本文标题: SQL语句删除重复记录且只保留一条有效记录
本文链接: https://www.lsjlt.com/news/391410.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-12
2024-05-12
2024-05-12
2024-05-12
2024-05-12
2024-05-12
2024-05-12
2024-05-11
2024-05-11
2024-05-11
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0