Re: SQL prodecure to compute ranking

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

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."