Re: Extract only maximum date from column

[Rich Shepard]

On Thu, 4 Dec 2025, David G. Johnston wrote:

So:
Select person.*, lastcontact.*
from people
join lateral (select contacts.*
     from contacts
     where contacts.person_nbr = people.person_nbr
     order by last_contact_date
     desc limit 1)
as lastcontact on true;

I was giving you a query form. You should use the actual table and column
names in your schema…

David,

The two table names are 'people' and 'contacts', the columns are
'person_nbr' and 'last_contact.' I usually use aliases rather than the table
name to reference the column.

Rich