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

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL prodecure to compute ranking

Re: SQL prodecure to compute ranking

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 10 Sep 2002 19:17:12 -0500
Message-ID: <u3csh2opk.fsf@hotpop.com>

On 10 Sep 2002, aalegrias_at_yahoo.com wrote:

> Basically, the requirements state that the high score board should
> display the top 5 scores, the users score (with rank) along with the 2
> above and 2 below. Of course if the user is in the top 10, it just
> returns the top 10.

Check out analytic functions. Those things rock!

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.
Received on Tue Sep 10 2002 - 19:17:12 CDT

Original text of this message

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