Ranking?

Hi list,

 

Wondering if you could help me out here? I've got a table like this:

 

id    name    data

1    sully        567

2    sully        789

3    sully        456

4    denan       890

5    denan        678

 

now I want to have this:

 

id    name    data    rank

1    sully        567    2

2    sully        789    1

3    sully        456    3

4    denan       890    1

5    denan        678    2

 

I'm think along the lines with count, something like this:

 

select id,name,data, (select count (names) from table as tmp where data.tmp > data.table) as rank

 

this (I know) is not correct. What would be?

 

Greetings sjors