?
SQL重復(fù)記錄查詢的幾種方法，需要的朋友可以參考一下
1、查找表中多余的重復(fù)記錄，重復(fù)記錄是根據(jù)單個字段（peopleId）來判斷
代碼如下:
select * from people
where peopleId in (select?? peopleId from?? people group by?? peopleId having count
(peopleId) > 1)
2、刪除表中多余的重復(fù)記錄，重復(fù)記錄是根據(jù)單個字段（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、查找表中多余的重復(fù)記錄（多個字段）
代碼如下:
select * from vitae a
where (a.peopleId,a.seq) in?? (select peopleId,seq from vitae group by peopleId,seq having
count(*) > 1)
4、刪除表中多余的重復(fù)記錄（多個字段），只留有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)文章來源：http://www.zghlxwxcb.cn/news/detail-662675.html
5、查找表中多余的重復(fù)記錄（多個字段），不包含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)
轉(zhuǎn)自：微點閱讀? ?https://www.weidianyuedu.com文章來源地址http://www.zghlxwxcb.cn/news/detail-662675.html
到了這里，關(guān)于分享SQL重復(fù)記錄查詢的幾種方法的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
