Postgres Pro
Downloads
Home   >   mailing lists

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

From Rich Shepard
Subject Re: Selecting table row with latest date
Date
Msg-id alpine.LNX.2.20.2108190740080.15165@salmo.appl-ecosys.com
Whole thread Raw
In response to Selecting table row with latest date  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Selecting table row with latest date  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view 
On Thu, 19 Aug 2021, Rich Shepard wrote:

> Please point me to the proper place in the docs where I can learn how to do
> this.

If I use DISTINCT ON would this produce the most recent date for each
person_nbr?

Rich

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Selecting table row with latest date
Next
From: Tom Lane
Date:
Subject: Re: Selecting table row with latest date