用SQL語句怎么過濾重復數(shù)據(jù)？1、查找表中多余的重復記錄，重復記錄是根據(jù)單個字段（peopleId）來判斷復制代碼代碼如下:select * from peoplewhere peopleId in

用SQL語句怎么過濾重復數(shù)據(jù)？

1、查找表中多余的重復記錄，重復記錄是根據(jù)單個字段（peopleId）來判斷復制代碼代碼如下:select * from peoplewhere peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)2、刪除表中多余的重復記錄，重復記錄是根據(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)