"Go" Oracle Delete duplicate records

Go to: http://blog.163.com/aner_rui/blog/static/12131232820105901451809/

2. Keep One (this should be what most people need ^_^)

Delete hzt Where ID not in (the Select Max (ID) from Hzt Group by Title)

Note: The maximum one record for the ID is retained here

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)

"Go" Oracle Delete duplicate records