Sql Server批量更新数据

最新推荐文章于 2024-09-24 15:55:51 发布

程序员思维

最新推荐文章于 2024-09-24 15:55:51 发布

阅读量5.4k

点赞数 1

分类专栏： SQL Server 文章标签： sql 数据库 sqlserver

本文链接：https://blog.csdn.net/qq_35434967/article/details/121604899

版权

SQL Server 专栏收录该内容

18 篇文章 1 订阅

订阅专栏

关联上一篇文章

Sql Server批量更新数据

--批量更新排名
UPDATE dbo.OA_UserRanking SET Ranking=cc.Ranking
FROM(
SELECT  ur.ID ,
        ur.EmployeeNo ,
        ur.EmployeeName ,
        ur.Year ,
        ur.DepartmentID ,
        ur.TotalScore ,
        COUNT(1) OVER ( PARTITION BY ur.Year, ur.DepartmentID ) AS TotalUser ,
        DENSE_RANK() OVER ( PARTITION BY ur.Year, ur.DepartmentID ORDER BY ur.TotalScore DESC ) AS Ranking
FROM    dbo.OA_UserRanking ur
) cc
WHERE cc.ID=dbo.OA_UserRanking.ID