ACCESS 排名 id可能是字符型,改为了int类型
在Access中怎么返回名次?
ACCESS总成绩排名问题 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)tmpwhere 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)tmpwhere cs_name='玩家名')先用select cs_name,sum(cs_d_f)as sumd from 表 group by cs_name order by sum(cs_d_f)desc取得排名表然后从排名表中找出总杀人数大于指定玩家杀人数的人数,该人数就是玩家的排名