I have table :
----------
...User ... Speed(minute)...
Maria 0.8
John 0.5
Alan 0.8
Anne 2.0
Smith 1.0
Kate 1.5
Evan 1.5
----------
--> I wanna set ranking for them such as:
Rank....User....Speed(minutes)
1 John 0.5
2 Maria 0.8
2 Alan 0.8
4 Smith 1.0
5 Kate 1.5
5 Evan 1.5
7 Anne 2.0
----------
Anyone can tell me how?
Thanks muchselect *,
(select count(1) + 1 from mytable t1 where t1.speed < t.speed) Rank
from mytable t
order by speed|||I run that query very well.
It's really excellent :]
Thanks so much, ehorn
No comments:
Post a Comment