大家好，又见面了，我是你们的朋友全栈君。
1，删除表中重复数据，仅保留重复数据id最小的
delete from yyd_wykl_goodsInfo
where skuId in (select skuId from (select skuId from yyd_wykl_goodsInfo group by skuId having count(skuId) > 1) a)
and id not in ( select id from (select min(id) as id from yyd_wykl_goodsInfo group by skuId having count(skuId )>1) b);
2，查找表中多余的重复记录（多个字段），不包含id最小的记录
select * from yyd_wykl_goodsInfo as s
where s.id,s.title in (select id,title from yyd_wykl_goodsInfo group by id,name having count(id)>1)
and s.id not in ( select min(id) as id from yyd_wykl_goodsInfo group by id,name having count(id )>1);
3，查找表中多余的重复记录，重复记录是根据单个字段（userId）来判断
select * from user
where userId in (select userId from usergroup by peopleId having count(userId) > 1)
4、查找表中多余的重复记录（多个字段）
select * from user a
where (a.userId,a.name) in (select userId,name from user group by userId,name having count(*) > 1)
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请联系我们举报，一经查实，本站将立刻删除。
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/105915.html原文链接：https://javaforall.net
