Hi,
I have a sql query :
SELECT b.ref_var, a.CLEF_VAR, b.libelle, c.ref_equip, MIN(DATE1), MAX (DATE1), c.libelle "Equipement"
FROM EVV_E030 a, c_variable b, C_EQUIP c
WHERE a.clef_var = b.clef_var
AND b.clef_equip = c.clef_equip
group by b.ref_var, a.CLEF_VAR, b.libelle, c.ref_equip, c.libelle
Table EVV_E030 is defined like this :
CREATE TABLE "EVV_E030" ( "DATE1" DATE, "HAUTEUR" NUMBER(6,3), "VALEUR" NUMBER(9,3) )
The SQL command retruns something like this :
W026E030T024 5015 E30 Trace pas de temps fixe E030 01/01/2015 00:00:00 11/09/2018 15:15:00 Meyer
W026E030M121 957 Seuil alarrme niveau bas Ex +1 E030 16/01/1996 09:50:40 23/03/2011 17:31:52 Meyer
W026E030M120 956 Seuil alerte niveau haut Ex +1 E030 16/01/1996 09:50:28 23/03/2011 17:31:52 Meyer
The table EVV_E030 contains a column "Valeur" that contains a value. I would like the SQL query to return also this value for the max(date1); for example (in red the value for the max(date1) :
W026E030T024 5015 E30 Trace pas de temps fixe E030 01/01/2015 00:00:00 11/09/2018 15:15:00 Meyer 534,23
W026E030M121 957 Seuil alarrme niveau bas Ex +1 E030 16/01/1996 09:50:40 23/03/2011 17:31:52 Meyer 432,78
W026E030M120 956 Seuil alerte niveau haut Ex +1 E030 16/01/1996 09:50:28 23/03/2011 17:31:52 Meyer 1029,32
Thank you for your help.