SQL SERVER 删除重复记录

查找重复记录

Select Row_Number() Over(Partition By [jlID],riq,dianl,diany,dianz,xiel,leix,zhenzh,baid,shijxljg order By jlid) As RowNumber,* From cxt.tenrpt16100139

 

删除重复记录

delete T from(Select Row_Number() Over(Partition By [jlID],riq,dianl,diany,dianz,xiel,leix,zhenzh,baid,shijxljg order By jlid) As RowNumber,* From cxt.tenrpt16100139) T

where T.RowNumber >1