Postgres Pro
Downloads
Home   >   mailing lists

Re: Subquery to select max(date) value - Mailing list pgsql-general

From Matt Zagrabelny
Subject Re: Subquery to select max(date) value
Date
Msg-id CAOLfK3W7w_O8A4zCeZQpRJPSHLzzYx00xRQ5cJ95TORLfKc7pQ@mail.gmail.com
Whole thread Raw
In response to Subquery to select max(date) value  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Tree view
Hey Rich,

On Tue, Feb 12, 2019 at 4:24 PM Rich Shepard <rshepard@appl-ecosys.com> wrote:
The query is to return the latest next_contact date for each person. Using
the max() aggregate function and modeling the example of lo_temp on page 13
of the rel. 10 manual I wrote this statement:

I use DISTINCT ON and ORDER BY to get the single latest value from a table with multiple date entries:


HTH,

-m

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Subquery to select max(date) value
Next
From: Adrian Klaver
Date:
Subject: Re: Subquery to select max(date) value