比如有一张表中:
id name count
1 a 5
2 b 4
3 c 2
4 d 6
5 e 8
6 f 3换order by count desc 排序。结出的结果为 id name count
1 5 e 8
2 4 d 6
3 1 a 5
4 2 b 4
5 6 f 3
6 3 c 2
这时我想知道name=a 排在第几时。SQL语句怎么来写?谢谢了!!!
id name count
1 a 5
2 b 4
3 c 2
4 d 6
5 e 8
6 f 3换order by count desc 排序。结出的结果为 id name count
1 5 e 8
2 4 d 6
3 1 a 5
4 2 b 4
5 6 f 3
6 3 c 2
这时我想知道name=a 排在第几时。SQL语句怎么来写?谢谢了!!!
SQL:
select sum(decode(zz.sna,'a',rownum,0)) as place
from (
select *
from tablename tt
order by cou desc
)zz;
Result:
PLACE
----------
3