SQL Server分数排序

1、并列排名

select 
IRID, 
ModelID,
mingci=DENSE_RANK() over(order by ModelID) 
from QuestionaryResult 
where MODELID is not null

 

 

2、顺序排名

SELECT 
ROW_NUMBER() OVER (ORDER BY MODELID)AS Number ,
ModelID
FROM QuestionaryResult WHERE MODELID=98