update column using specific order

Hi all,

I would like to populate a given column in a table like this:

Name Salary SalaryRank
---- ------- --------

Smith 100000
John 350000
McDo 220000
Corny 110000

And finally obtain in the SalaryRank, the rank of the salary comparing to all the salary in this table like this:

Name Salary SalaryRank
---- ------- --------

Smith 100000     4
John  350000     1
McDo  220000     2
Corny 110000     3

Is it possible using an update command ? Thanks. Received on Wed Mar 03 2004 - 09:51:50 CST