David G. Johnston writes:
> SELECT DISTINCT ON (jid) jid, timestamp, scf, energy [...] ORDER BY jid,> scf DESC
Got it.
Many thanks,Roger