SQL statement for querying and deleting duplicate records

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

SELECT * from People

where Peopleid in (select Peopleid from People GROUP by Peopleid have count (Peopleid) > 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 from people

where Peopleid in (select Peopleid from People GROUP by Peopleid have count (Peopleid) > 1)

and rowID not in (select min (rowid) from people GROUP by Peopleid have Count (Peopleid) >1)

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

SELECT * FROM Vitae a

where (A.PEOPLEID,A.SEQ) in (select Peopleid,seq from Vitae GROUP by PEOPLEID,SEQ have count (*) > 1)

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

Delete from Vitae a

where (A.PEOPLEID,A.SEQ) in (select Peopleid,seq from Vitae GROUP by PEOPLEID,SEQ have count (*) > 1)

and rowID not in (select min (rowid) from Vitae GROUP by PEOPLEID,SEQ have Count (*) >1)

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

SELECT * FROM Vitae a

where (A.PEOPLEID,A.SEQ) in (select Peopleid,seq from Vitae GROUP by PEOPLEID,SEQ have count (*) > 1)

and rowID not in (select min (rowid) from Vitae GROUP by PEOPLEID,SEQ have Count (*) >1)

Delete from table name where field ID in (SELECT * FROM ( field ID) from table name group by repeating field having count ( repeating field ) > 1) as B);

SQL statement for querying and deleting duplicate records