Home > mailing lists

Re: select from grouped data - Mailing list pgsql-novice

From	Roger Mason
Subject	Re: select from grouped data
Date	August 25, 2021 16:59:10
Msg-id	y65ilztd3rl.fsf@mun.ca Whole thread Raw
In response to	Re: select from grouped data ("David G. Johnston" <david.g.johnston@gmail.com>)
List	pgsql-novice

David G. Johnston writes:

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

Got it.

Many thanks,
Roger

From: "David G. Johnston"
Date: 25 August 2021, 16:19:39
Subject: Re: select from grouped data

From: Stephen Frost
Date: 25 August 2021, 23:42:56
Subject: Re: select from grouped data