Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Strange query result with Order by
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