How to get a row rank?

Programming in mysql: How to get a row rank? on newest questions tagged mysql – Stack Overflow

HI,

I actually posted similar (or same?) question yesterday, but I thought I need to post a new question since I have short, but clear question.

I have the following table.

id  point
1   30
2   30
3   29
4   27
5   28
6   26

what I want:

1. get all the users order by rank. user #1 and #1 should have 1 as their rank value because they both of them have 30 points

2. I want to query a rank by user id. I like to get 1 as the result of my rank when I query user #1 and #2 because both of them have 30 points

I tried to google, search stackoverflow, and made various queries, but none of them worked…

please help me!

Added on: 3/18

I tried Logan’s query, but got the following result

id point   rank
1   30  1
2   30  1
3   29  3
4   27  5
5   28  4
6   26  6

source: http://stackoverflow.com/questions/5347565/how-to-get-a-row-rank
Programming in mysql: programming-in-mysql