用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)

sql查詢語句過濾重復數(shù)據(jù)？

SELECT Id，SiteId，InsertTime，IP，Referrer，Url FROM ( SELECT ROW_NUMBER()OVER(PARTITION BY IP ORDER BY Id DESC) number， Id，SiteId，InsertTime，IP，Referrer，Url From YourTable )T where number = 1 拿走不謝