Sv: ranking in Oracle

Yes, if you are using 8.1.6

/karsten

Mark van Dijk <markvandijk_at_deja.com> skrev i en nyhedsmeddelelse:TCrk$sFs$GA.250_at_asd24-aux-005.tis.telfort.net...
> 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