Re: select from grouped data

From: Roger Mason <rmason(at)mun(dot)ca>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: select from grouped data
Date: 2021-08-25 13:59:10
Message-ID: y65ilztd3rl.fsf@mun.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


David G. Johnston writes:

> SELECT DISTINCT ON (jid) jid, timestamp, scf, energy [...] ORDER BY jid,
> scf DESC

Got it.

Many thanks,
Roger

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Stephen Frost 2021-08-25 20:42:56 Re: select from grouped data
Previous Message David G. Johnston 2021-08-25 13:19:39 Re: select from grouped data