Re: SQL prodecure to compute ranking

Definitely worth doing, since the analytic features are not available to standard edition.

Your pl/sql produces the method that the analytic functions label as 'dense_rank()' by the way.

If two people tie for third place, the next person is given 5th place if you want to emulate the rank() function.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____England______September 24/26, November 12/14

____USA__________November 7/9 (MI), 19/21 (TX)

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html








Candido Dessanti wrote in message <3D81DF36.1010408_at_blunet.it>...


>

>Yap, but i wanted to give just a minimal solution and i just simplified

>what he is using now without the use of analytical functions just using

>plain sql; anyway you can always add something like a timestamp for the

>user first registration to avoid ties.