2009/11/20 Massa, Harald Armin <chef@xxxxxxx>
> > Is it possible? How would the SQL utilizing WINDOW-functions look like?and how would I use DISTINCT ON for this query? Please bear in mind,
>
> there is no point in using window functions in here - simply use
> "DISTINCT ON".
that there is more then one id_bf (just stopped the sample data with
one of them)
Best wishes,
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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Would this work?
SELECT DISTINCT ON (id_bf) id_bf, wert, letztespeicherung
FROM rfmitzeit
ORDER BY id_bf, letztespeicherung ASC;
Regards
Thom
