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