环境: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 可以跟多个条件 参考