Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.glorb.com!postnews1.google.com!not-for-mail
From: brovreizh@yahoo.fr (Brovreizh)
Newsgroups: comp.databases.oracle.misc
Subject: update column using specific order
Date: 3 Mar 2004 07:51:50 -0800
Organization: http://groups.google.com
Lines: 23
Message-ID: <5b92b5ad.0403030751.bdd8df8@posting.google.com>
NNTP-Posting-Host: 212.234.51.85
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1078329110 25053 127.0.0.1 (3 Mar 2004 15:51:50 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 3 Mar 2004 15:51:50 +0000 (UTC)
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:136491

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.