SQLserver 删除完全重复的数据 只留一条

--查询重复数据,确认
select * From (Select Row_Number() Over(Partition By [Name] order By [ID]) As RowNumber,* From Student)T Where T.RowNumber > 1 ---删除重复数据 Delete T From (Select Row_Number() Over(Partition By [Name] order By [ID]) As RowNumber,* From Student)T Where T.RowNumber > 1

  

posted @ 2022-02-21 15:03  薛李淑月  阅读(440)  评论(0编辑  收藏  举报