SQL Server deletes duplicate records

In the system to a customer on-line found that there is a table of duplicate data, the results by troubleshooting code to find that there is a problem with the business logic, after modifying the code needs to be in the database of data deduplication on CSDN to find a solution, do not delete the database on the wire as much as possible, and you should back up the database regardless of any action on the database on the line

  
 

   
  

  
--删除重复的记录
   
  

  
delete from table1 
   
  

  
--根据Uid号获取重复的记录
   
  

  
where uid in (select uid from table1 group by uid having count(uid) > 1)
   
  

  
--排除保留最新的ID号,其他的删除
   
  

  
and id not in (select max(id) from table1 group by uid having count(uid )>1)
  
 

Reference: CSDN SQL Duplicate record query

From for notes (Wiz)

SQL Server deletes duplicate records