Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL prodecure to compute ranking
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