I found some good answers for this question, but I can't really get them to work. 

I wan't to get a players rank from a hiscore table. 

```
id   name   score

1    John    10
2    Linda   5
3    Emmy    25 

```

I want to pass in a name in the query (Linda) and get her rank (She only have 5 points in the table above), and get her rank (nr 3). 

I found a similar question with this answer, but don't understand it: 

```
SELECT  uo.*, 
    (
    SELECT  COUNT(*)
    FROM    users ui
    WHERE   (ui.points, ui.id) >= (uo.points, uo.id)
    ) AS rank
   FROM    users uo
   WHERE   id = @id

```

Thanks in advance