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