Postgres Pro
Downloads
Home   >   mailing lists

Re: Selecting table row with latest date - Mailing list pgsql-general

From David G. Johnston
Subject Re: Selecting table row with latest date
Date
Msg-id CAKFQuwb0S+PG=BoALF5yD-0GkthB7adq27P0hzH8QQTW-sEOQA@mail.gmail.com
Whole thread Raw
In response to Selecting table row with latest date  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Selecting table row with latest date  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Tree view
On Thursday, August 19, 2021, Rich Shepard <rshepard@appl-ecosys.com> wrote:
I have a table of contacts (PK is the person_nbr and contact_date)


Select distinct on (person_nbr) ….. order by person_nbr, contact_date desc;

David J.
 

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Selecting table row with latest date
Next
From: Rich Shepard
Date:
Subject: Re: Selecting table row with latest date