Postgres Pro
Downloads
Home   >   mailing lists

Re: How to select avg(select max(something) from ...) - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: How to select avg(select max(something) from ...)
Date
Msg-id CAKAnmm+yfxQF1c_BvB83s5tShcxNiwc0iP5Wxfy_ti2fVVRvoA@mail.gmail.com
Whole thread Raw
In response to Re: How to select avg(select max(something) from ...)  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
Another variation:

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


Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to select avg(select max(something) from ...)
Next
From: Schmid Andreas
Date:
Subject: PGDG PostgreSQL Debian package: Question on conditions for creation of new cluster