ROW_NUMBER()与PARTITION BY 实例

环境:SQL Server 2008 R2

数据表结构

SELECT A.*
FROM [tbiz_AssScoreWeidu] A
WHERE  A.ProjectID=65 AND A.PersonID=2430 AND A.RelationID=30

 

SELECT A.*
,ROW_NUMBER() OVER
      (
        PARTITION BY A.[WeiduNo]
        ORDER BY  A.[ID] 
      )
      AS rn
FROM [tbiz_AssScoreWeidu] A
WHERE  A.ProjectID=65 AND A.PersonID=2430 AND A.RelationID=3

 

 PARTITION BY 可以跟多个条件 参考