ACCESS总成绩排名问题

2025-05-23 23:20:06

推荐回答（2个）

回答（1）：

select count(1) from
(select cs_name,sum(cs_d_f) as sumd from 表 group by cs_name order by sum(cs_d_f) desc)tmp
where sumd>=(select sumd from
(select cs_name,sum(cs_d_f) as sumd from 表 group by cs_name order by sum(cs_d_f) desc)tmp
where cs_name='玩家名')

先用select cs_name,sum(cs_d_f) as sumd from 表 group by cs_name order by sum(cs_d_f) desc取得排名表
然后从排名表中找出总杀人数大于指定玩家杀人数的人数，该人数就是玩家的排名

回答（2）：

保持沉默