Delete the duplicate records specified in SQL Server data

Delete from table where primary key = (select top 1 primary key from table where same field = (Select same field from table group by same field having count (*) >1))

A primary key is a field in a table that has absolutely no duplicate values, such as an AutoIncrement ID;

Same field such as "Collection Time", delete the record of the same time in the table

This statement, each time, can only delete a duplicate record, if there are three records have the same "collection Time", it is necessary to loop through the statement two times.