摘要：
今天查看了表，发现重复记录N多,然后做了一下实例，给大家分享一下，嘿嘿！1、查找表中多余的重复记录，重复记录是根据单个字段（RKEY）来判断select*fromDATA9287whereRKEYin(selectRKEYfromDATA9287groupbyRKEYhavingcount(RKEY)>1)例二：select * from testtablewhere numeber in (select number from DATA9287 group by number having count(number) > 1 )可以查出testtable表中number相同的记录 阅读全文