小阿

摘要： 1、查找表中多余的重复记录，重复记录是根据单个字段（DocId）来判断select * from TableNamewhere DocId in (select DocId from TableName group by DocId having count(DocId) > 1)例二：select * from TableNamewhere UserName in (select UserName from TableName group by TableName having count(TableName) > 1 )可以查出表中UserName相同的记录2、删除表中多余的重 阅读全文