名次算法(sql server)(转自：爱新觉罗.毓华)

表jh03有下列数据：name　scoreaa　　99bb　　56cc　　56dd　　77ee　　78ff　　76gg　　78ff　　501. 名次生成方式1,Score重复时合并名次SELECT *　,　Place=(SELECT COUNT(DISTINCT Score) FROM jh03 WHERE Score >= a.Score)FROM jh03 aORDER BY Place结果Name Score Place ---------------- ----------------- ----------- aa 99.00 1ee 78.00 2gg 78.00 2dd 77.00 3ff 76.00 4bb 56.00 5cc 56.00 5ff 50.00 62. 名次生成方式2 , Score重复时保留名次空缺SELECT * , Place=(SELECT COUNT(Score) FROM jh03 WHERE Score > a.Score) + 1FROM jh03 aORDER BY Place结果Name Score Place --------------- ----------------- ----------- aa 99.00 1ee 78.00 2gg 78.00 2dd 77.00 4ff 76.00 5bb 56.00 6cc 56.00 6ff 50.00 8