Methods for querying duplicate records in a database

Select *  from [DataBase].[dbo].[TableName]  where [Field One] inch(Select [Field One]  from [DataBase].[dbo].[TableName]  Group  by [Field One]  having Count([Field One])> 1)

1, look for redundant records in the table, duplicate records are based on a single field (Peopleid) to determine

Select *  from  where in (selectfrom    Group by   having Count > 1)

2, delete redundant records in the table, duplicate records are based on a single field (Peopleid) to judge, leaving only the smallest ROWID records

Delete  frompeoplewherePeopleidinch(SelectPeopleid fromPeopleGroup  byPeopleid having Count(Peopleid)> 1)  androwID not inch(Select min(ROWID) fromPeopleGroup  byPeopleid having Count(Peopleid)>1)

3. Find redundant duplicate records (multiple fields) in the table

Select *  from  wherein  (theselectfromgroupby has  Count(*>1)

4. Delete extra duplicate records (multiple fields) in the table, leaving only the record with ROWID minimum

Delete  fromVitae awhere(A.PEOPLEID,A.SEQ)inch(SelectPeopleid,seq fromVitaeGroup  byPeopleid,seq having  Count(*)> 1)  androwID not inch(Select min(ROWID) fromVitaeGroup  byPeopleid,seq having Count(*)>1)

5. Find redundant duplicate records (multiple fields) in the table, not including the smallest ROWID records

Select *  fromVitae awhere(A.PEOPLEID,A.SEQ)inch(SelectPeopleid,seq fromVitaeGroup  byPeopleid,seq having  Count(*)> 1)  androwID not inch(Select min(ROWID) fromVitaeGroup  byPeopleid,seq having Count(*)>1)