sql按条件过滤重复 用SQL语句怎么过滤重复数据？

用SQL语句怎么过滤重复数据？

1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断复制代码代码如下:select * from peoplewhere 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)

sql按条件过滤重复 sql重复数据只取一条 sql过滤重复数据

版权声明：本文内容由互联网用户自发贡献，本站不承担相关法律责任.如有侵权/违法内容,本站将立刻删除。