sql server批量删除重复数据

-- 批量删除重复数据
delete t from
(
select row_number() over(partition by user_code order by id) as rowNumber,* 
from t_user
)t
where t.rowNumber > 1

 

posted @ 2022-07-29 15:36  一隅桥畔  阅读(112)  评论(0)    收藏  举报