Rank() or Partition by Bug??

From: Yanick Hudon <yannik_at_sympatico.ca>
Date: Fri, 5 Jul 2002 23:17:38 -0700
Message-ID: <JxtV8.13350$P53.2054068@news20.bellglobal.com>

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. Received on Sat Jul 06 2002 - 01:17:38 CDT