SQL server 删除重复数据，只保留一条。

Delete T From
(Select Row_Number() Over(Partition By OrderNo order By OrderNo) As RowNumber,* From T_Production where OrderNo='P201102001')T
Where T.RowNumber > 1

 

 

Delete T From
(Select Row_Number() Over(Partition By 列名 order By 列名) As RowNumber,* From 表名 where 查询条件)T
Where T.RowNumber > 1