sql server删除重复的数据


delete t from
(Select Row_Number() Over(Partition By [重复的字段] order By [唯一索引如:主键ID]) As rorwsnum* From 表名) t Where t.rorwsnum> 1

posted @ 2021-09-07 17:19  阿磊小哥哥呀  阅读(124)  评论(0编辑  收藏  举报