这个sql问题如何写

[shiyangIgo]

有数据表
username votenum
a 15
b 20
c 30
写一个sql语句查询出用户所对应的票数排行

如：输入c 查询的结果为：1

[welyngj]

select rn from
(select username,row_number() over(order by votenum) rn from tbl) t 
where username='c'

[robin_ares]

[Quote=引用 1 楼 welyngj 的回复:]
SQL codeselect rn from
(select username,row_number() over(order by votenum) rn from tbl) t
where username='c'
[/Quote]
select rn from
(select username,row_number() over(order by votenum desc) rn from tbl) t
where username='c'

[tiantom]

已经有答案了，来晚了

[edgethinking]

Select username, votenum, (Select count(*) + 1 from tbl where votenum > t.votenum) from tbl t
order by votenum desc