Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Strange query result with Order by

Strange query result with Order by

From: Chris <christianboivin1_at_hotmail.com>
Date: 25 Nov 2004 05:30:59 -0800
Message-ID: <da20daf0.0411250530.4d7a6d3a@posting.google.com>


Hi all,

First time i see this ... when i run this query :

 SELECT hev_annee_deb, hev_annee_fin, hev_id_uef, hev_valeur_t, hev_valeur_b,

          NVL (hev_valeur_t, 0) + NVL (hev_valeur_b, 0) valeur_totale, HEV_PCT_VARIATION

     FROM HIS_EVAL
    WHERE hev_id_uef = 1449902
 ORDER BY hev_annee_deb DESC

i got 1 row ...

2002,2002,1449902,23500,84700,108200,

if i remove the descending order ... like this

 SELECT hev_annee_deb, hev_annee_fin, hev_id_uef, hev_valeur_t, hev_valeur_b,

          NVL (hev_valeur_t, 0) + NVL (hev_valeur_b, 0) valeur_totale, HEV_PCT_VARIATION

     FROM HIS_EVAL
    WHERE hev_id_uef = 1449902
 ORDER BY hev_annee_deb 

i got 2 row ...

2001,2001,1449902,23500,61700,85200,
2002,2002,1449902,23500,84700,108200,

What's the problem ... ?
Thanks
Chris Received on Thu Nov 25 2004 - 07:30:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US