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

From Adrian Klaver
Subject Re: Selecting table row with latest date
Date
Msg-id 27de6c2f-4c60-5985-9b1e-469ae633ca1c@aklaver.com
Whole thread Raw
In response to Selecting table row with latest date  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On 8/19/21 7:37 AM, Rich Shepard wrote:
> I have a table of contacts (PK is the person_nbr and contact_date) and I
> want to select only the row with the latest (most recent) contact_date. The
> Comparison Date/Time sections in the postgres 12 doc doesn't appear to have
> what I want, and when I try to use the max() aggregate function it 
> throws an
> error.

Show the query and the error you received.


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


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

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