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

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: dfgpostgres <dfgpostgres3(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to select avg(select max(something) from ...)
Date: 2025-02-19 00:10:06
Message-ID: CAKAnmm+yfxQF1c_BvB83s5tShcxNiwc0iP5Wxfy_ti2fVVRvoA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Schmid Andreas 2025-02-19 08:45:53 PGDG PostgreSQL Debian package: Question on conditions for creation of new cluster
Previous Message Adrian Klaver 2025-02-18 22:17:52 Re: How to select avg(select max(something) from ...)