Re: Complex Query again!

Hi Yanick,

your dbms and data model would be of help, i didn't exactly catch the meaning
of your first question and didn't want to read too long ;-).

So, just a little info regarding your question number 2, no help. According to the 8i SQL reference the function RANK *always* adds the number of tied rows to calculate the next rank. Therefore, the ranks may not be consecutive.

Maybe one of the real Gurus has a trick for you...

Greetings,
Guido

"Yanick Hudon" <yannik_at_sympatico.ca> wrote...
> Hi to All,
>
> I've finally found what i wanted for a complex query which is ranking
> according to a player
> who can play in different levels and is allowed to subscribe to 1
level
> only.
>
> But now, i have two simple questions:
>
> 1. Is there a way to do it less complicated??
> 2. Is there a way to have the field "Rang" following the previous when
> it comes after the 10th position??

<SNIP>

> Thanks in advance for your help!
>
>
Received on Wed Jul 17 2002 - 08:14:15 CDT