sqlserver 2000做排名函数

sqlserver 2000排名函数

名次生成方式1,重复时合并名次

SELECT *　,　Place=(SELECT COUNT(DISTINCT Score) +1 FROM jh03 WHERE Score >= a.Score)
FROM jh03 a
ORDER BY Place

 

 名次生成方式2 , 重复时保留名次空缺
SELECT * , Place=(SELECT COUNT(Score) FROM jh03 WHERE Score > a.Score) + 1
FROM jh03 a
ORDER BY Place