Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> ranking in Oracle

ranking in Oracle

From: Mark van Dijk <markvandijk_at_deja.com>
Date: 2000/04/27
Message-ID: <TCrk$sFs$GA.250@asd24-aux-005.tis.telfort.net>#1/1 






Hi,



is it possible to rank a query, i.e. put the rank number in a column?
For example:


a 3.65
b 9.87
c 1.23





Then the output must be:


a 2


b 3


c 1



Thanks!
Received on Thu Apr 27 2000 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US