select [username],sum([money])as [money],row_number() over(order by sum([money]) desc) paiming
from [rrlgame].[dbo].[account]group by [username]
结果是
姓名 排名
admin 1
login 2
user 3
from [rrlgame].[dbo].[account]group by [username]
结果是
姓名 排名
admin 1
login 2
user 3
怎么取一个用户的排名
比如只要admin排在1位
select count(*)
from account
where [money]>=(select [money] from account where username='admin')