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