SQL Language (MOSC)

MOSC Banner

RANK behaving strangely on Oracle 9.2

edited Sep 5, 2012 10:41PM in SQL Language (MOSC) 4 commentsAnswered ✓
Hi, 
I'm facing a strange behaviour of the RANK() function on an old Oracle 9.2 database.

Here is the SQL Query : 
SELECT 
    RANK() OVER (order by mco_rum.date_sortie NULLS FIRST) AS NUM,
    COUNT(*) OVER (order by mco_rum.date_sortie NULLS FIRST) CTN,
    mco_rum.identifiant AS idRUM,
    TO_CHAR(mco_rum.date_entree,'DD/MM/YYYY'),
    TO_CHAR(mco_rum.date_sortie,'DD/MM/YYYY'),
    mco_rum.codeunitesoin,
    mco_rum.verrou,
    mco_mode_entree.libelle AS modeEntree,
    mco_mode_sortie.libelle AS modeSortie,
    mco_rss.identifiant    AS idRSS,
    mco_rss.numero_hospitalisation,
    mco_resultat.cmd,
    mco_resultat.code_retour,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center