建站
咨詢
售后
建站咨詢
新聞中心
DB2刪除重復記錄得方法和其他數(shù)據(jù)庫系統(tǒng)有何不同呢？下文為您列舉了五種DB2刪除重復記錄的情況，希望對您有所啟迪。
讓客戶滿意是我們工作的目標，不斷超越客戶的期望值來自于我們對這個行業(yè)的熱愛。我們立志把好的技術通過有效、簡單的方式提供給客戶，將通過不懈努力成為客戶在信息化領域值得信任、有價值的長期合作伙伴，公司提供的服務項目有：空間域名、虛擬主機、營銷軟件、網(wǎng)站建設、思茅網(wǎng)站維護、網(wǎng)站推廣。
1、查找表中多余的重復記錄，重復記錄是根據(jù)單個字段（peopleId）來判斷
select * from people where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2、DB2刪除重復記錄，重復記錄是根據(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、查找表中多余的重復記錄（多個字段）
select * from vitae a where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)
4、DB2刪除重復記錄（多個字段），只留有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)
【編輯推薦】
aix環(huán)境下創(chuàng)建DB2數(shù)據(jù)庫的方法
九個DB2常用命令
aix下DB2創(chuàng)建表空間的方法
windows下DB2創(chuàng)建表空間的實現(xiàn)
教您如何在DB2刪除數(shù)據(jù)量大的表
分享標題：DB2刪除重復記錄的五種情況
URL鏈接：http://fisionsoft.com.cn/article/cddeipe.html
