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

On Thu, 19 Aug 2021, Rob Sargent wrote:

> sorry, wasn’t clear: person_nbr, next_contact
> On the premise that there can only be one next date.

Rob,

I wasn't sufficiently clear. The contacts table has a row for each
(person_nbr, contact_date). For each row there's also either a next_contact
date or that column is null (e.g., pandemic-related no longer at that
company).

Regards,

Rich