Horton

Re: How to select avg(select max(something) from ...)

Greg Sabino Mullane <htamfids@gmail.com>

View thread View on postgr.es
From: Greg Sabino Mullane <htamfids@gmail.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: dfgpostgres <dfgpostgres3@gmail.com>, pgsql-general@lists.postgresql.org
Date: 2025-02-19T00:10:06Z
Lists: pgsql-general 
Another variation:

select avg(max) from (select distinct max(val) over(partition by id) from
mytable);


Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support