sqlserver 删除重复的数据
Delete T From
(Select Row_Number() Over(Partition By ExamSoluID,UserID, TurnProportion,TurnStandardSectionID order By ID) As RowNumber,* From TblUserTurnMx)T
Where T.RowNumber > 1
Delete T From
(Select Row_Number() Over(Partition By ExamSoluID,UserID, TurnProportion,TurnStandardSectionID order By ID) As RowNumber,* From TblUserTurnMx)T
Where T.RowNumber > 1