Re: Rank() or Partition by Bug??

> Hi to all,
>
> I want to know if there's a bug in those functions in Oracle 9i
> because when i make the results out after a golf tournament, it
> seems to be a
> problem
> with some golfers whose get a result.
>
> I'm joining my query:
>
> SELECT
> Prenom,
> nom,
> nomclasse,
> ScoreBrut,
> RANK() OVER (Partition By Classesmembres.classeid order by ScoreBrut
> asc)
> as Rang
> FROM inscriptionstournois,
> golfeurs,
> Adherants,
> classesmembres,
> Classes,
> ResultatsTournois
> WHERE (Inscriptionstournois.golfeurid = golfeurs.golfeurid
> AND Adherants.golfeurID = golfeurs.golfeurID
> AND Adherants.MembreID = classesmembres.MembreID
> AND ClassesMembres.ClasseID = Classes.ClasseID
> AND Resultatstournois.golfeurID = Adherants.golfeurID
> AND InscriptionsTournois.Evenementid = 31)
>
> Any helps would be appreciated.
> Thanks in advance.

It's unclear what this query returns and why you think the result is a bug, so it's equally impossible to help you.

Rene

-- 
Recherchen im schweizerischen Handelsregister: 
http://www.adp-gmbh.ch/SwissCompanies/Search.php3