深圳网站建设技术博客

1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断 

select * from people 

where peopleId in (select  peopleId  from  people  group  by  peopleId  having  count(peopleId) > 1) 

More...