Re: Selecting table row with latest date

On Thu, 19 Aug 2021, Rob Sargent wrote:

> Did you try David J’s suggestion? or maybe

Rob,

Yes.

> select person_nbr, max(next_contact) group by person_nbr where
> next_contact < now();

> A table with person_nbr (pk), next_contact would make this much easier.
> Seems to me a person can only have one next-contact? (as opposed to all
> future_contact)

The peoples table has person_nbr as the PK. The contacts table has multiple
rows for all contacts with that person_nbr. The contacts table has a
multicolum PK: person_nbr and contact_date as there is only one contact on
any given day for that person.

HTH,

Rich