Re: Selecting table row with latest date

[Rob Sargent]

> On Aug 19, 2021, at 11:20 AM, Rich Shepard <rshep...@appl-ecosys.com> wrote:
> 
> 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).
> 

Yeah, I get that each person may have been contacted more than once for a 
history of contacting.  I just feel that “next_contact” doesn’t belong there.
> Regards,
> 
> Rich
> 
>