You don't include the where clause, just the having clause after the
group by.
At least that is what I remember. But it has been awhile.
*Bryan Sayer*
Retired Demographer/Statistician
/In a world in which you can be anything, *be kind*/
On 12/4/2025 3:13 PM, Rich Shepard wrote:
> On Thu, 4 Dec 2025, Bryan Sayer wrote:
>
>> I believe in general you need
>>
>> having c.next_contact = max(c.next_contact)
>>
>> (at least in ANSI SQL) Use having for after the join has occurred
>
> Bryan,
>
> Postgresql didn't like that regardless of where I inserted the `having'
> stanza.
>
> Thanks,
>
> Rich
>
>