id_bf, wert, letztespeicherung: > 98, 'blue', 2009-11-09 >> 98, 'red', 2009-11-10 >> now I have a select to get the "youngest value" for every id_bf: >> > > Not tested: > > SELECT id_bf, wert, > max(letztespeicherung) over (partition by id_bf) > FROM rfmitzeit >
no, that does not work: "id_bf";"wert";"max" 98;"blue";"2009-11-10 00:00:00" 98;"red";"2009-11-10 00:00:00" result is: I get the date of the youngest value. My expected result is: 98;"red" (that is, the entry of "wert" that is youngest) thanks for trying, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pigeon - %s is too gigantic of an industry to bend to the whims of reality
