public inbox for [email protected]  

help / color / mirror / Atom feed

From: Rich Shepard <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: Extract only maximum date from column
Date: Fri, 5 Dec 2025 05:41:44 -0800 (PST)
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAKFQuwaTe2vX30erug=2v0G5BL3G=vYvwNC-8jJFkKUe3EimEQ@mail.gmail.com>
References: <[email protected]>
	<CAKFQuwZEWkgQeWSB7nqzBjHS8kP7kvouT6jhKvfe_G2e3cJvOQ@mail.gmail.com>
	<[email protected]>
	<CAKFQuwbzjjBi7YV1gSn=2jX7h-FK8kf8fbpWmpYqX-8pSD7beA@mail.gmail.com>
	<[email protected]>
	<CAKFQuwaTe2vX30erug=2v0G5BL3G=vYvwNC-8jJFkKUe3EimEQ@mail.gmail.com>

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

view thread (16+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Extract only maximum date from column
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox