Re: SQL prodecure to compute ranking

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 12 Sep 2002 23:58:11 +1000
Message-ID: <uW0g9.30589$g9.87929@newsfeeds.bigpond.com>

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:3D7FB1C3.46A6_at_yahoo.com...
> 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 ???

ERROR at line 1:
ORA-00933: SQL command not properly ended

You have too many parentheses at the end ;)

Hee hee

Richard

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

>

> http://www.oracledba.co.uk

>
> "Some days you're the pigeon, some days you're the statue..."
Received on Thu Sep 12 2002 - 08:58:11 CDT