首页 > 教程 >
织梦网站MYSQL查询重复记录的方法
2023-02-27教程围观次
简介1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断select*frompeoplewherepeopleIdin(selectpeopleIdfrompeoplegroupbypeopleIdhavingcount(peopleId)>1)2、删除表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断,只留有rowid最小的记录deletefrompeop
1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2、删除表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断,只留有rowid最小的记录
delete from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
and rowid not in (select min(rowid) from people group by peopleId having count(peopleId )>1)
3、查找表中多余的重复记录(多个字段)
select * from vitae a
where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)
4、删除表中多余的重复记录(多个字段),只留有rowid最小的记录
delete from vitae a
where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)
and rowid not in (select min(rowid) from vitae group by peopleId,seq having count(*)>1)
5、查找表中多余的重复记录(多个字段),不包含rowid最小的记录
select * from vitae a
where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)
and rowid not in (select min(rowid) from vitae group by peopleId,seq having count(*)>1)
下载链接:网站源码/小程序源码/网站模板下载
下载排行
- 群多多社群人脉H5-2.1.4多开插件+小程序独立前端+搭建教程
- 慧眼识花草微信小程序源码/植物辨别微信小程序源码
- 微信小程序格创校园跑腿小程序源码v1.1.64+前端
- 抖音艺术签名小程序源码/艺术签名设计小程序源码/字节跳动小程序开发
- 最新仿720云全景制作源码|krpano仿720云全景网站源码
- 图片编辑小程序源码/拼图小程序源码
- 美女图片站 CX-UDY3.1最新破解版全解密去授权版无限制
- 苹果CMS V10专享版MXoneV10.6魔改版影视网站模板/二开大气短视频网站模板
- 最新Rimini主题 1.3.0 资源付费WordPress主题下载
- 简约自适应wordpress博客二次元主题qzdy4.3