Use SQL Server cursor to delete duplicate records

During this time, the project needs to import the original data to the new database, and the duplicate data needs to be deleted. I use the cursor method to solve this problem. The SQL statement is as follows to avoid forgetting. Code

-- Delete duplicate data. Only the records with the largest number are retained.
Declare Mycursor Cursor  
For
Select Addinip From Testdb Group   By Addinip Having   Count (Addinip) > 1
Open Mycursor
Declare   @ IP Sysname
Fetch   Next   From Mycursor Into   @ IP
While ( @ Fetch_status = 0 )
Begin
Print   @ IP
Declare   @ Aid   Int  
Select   @ Aid = Max (Autoid) From Testdb Where Addinip = @ IP
Print   @ Aid
-- Delete duplicate data. Only the record with the largest record number is retained.
Delete   From Testdb Where Autoid <>   @ Aid   And Addinip = @ IP

Fetch Next FromMycursorInto @ IP
End
CloseMycursor
DeallocateMycursor