Re: SQL prodecure to compute ranking

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 11 Sep 2002 11:01:43 +1000
Message-ID: <Aswf9.29177$g9.84134@newsfeeds.bigpond.com>

Hi Galen,

Yeah they do, but they also hurt my head trying to worked them all out. Sum and Avg I can cope with but anything else and I just go ga ga ...

Cheers

Richard
"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message news:u3csh2opk.fsf_at_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 - 20:01:43 CDT