Re: SQL prodecure to compute ranking

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

On Wed, 11 Sep 2002, connor_mcdonald_at_yahoo.com wrote:

> Richard Foote wrote:

>>
>> 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.

> 
> How hard can
> 
> select 
>  partition rank first ( extra brackets ( another bracket )
>    ( bracket surrounding more stuff )
>  ( order by ( something about a window ))))
> 
> be ???

And people complain about the parentheses in Lisp. :-)

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.

Received on Thu Sep 12 2002 - 19:36:10 CDT