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,
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 occured
*Bryan Sayer*
Retired Demographer/Statistician
/In a world in which you can be anything, *be kind*/
On 12/4/2025 2:55 PM, Rich Shepard wrote:
I want the
I am not very skilled at Postgresql specifically, but when I was doing
SQL in another environment I would just do
select distinct (or unique) jobtitle
usually getting a count of how many times each title occurred. Then I
would create a mapping to standardize the the job titles.
*Bryan Sayer
ws 11, with everything on local drives.
--
*Bryan Sayer*
Retired Demographer/Statistician
/In a world in which you can be anything, *be kind*/
