Search Postgresql Archives
Re: How to select avg(select max(something) from ...)
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: How to select avg(select max(something) from ...)
From
: Greg Sabino Mullane <htamfids@xxxxxxxxx>
Date
: Tue, 18 Feb 2025 19:10:06 -0500
Cc
: dfgpostgres <dfgpostgres3@xxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxxxxxxxx
In-reply-to
: <
0878c968-a3d6-4803-a5b8-3ac1eb876309@aklaver.com
>
References
: <CAAcmDX8Xs5+NbSV1UGUsj06yQpC=wYj_FOfTMZNvFe6uXDTqcw@mail.gmail.com> <
0878c968-a3d6-4803-a5b8-3ac1eb876309@aklaver.com
>
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
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
References
:
How to select avg(select max(something) from ...)
From:
dfgpostgres
Re: How to select avg(select max(something) from ...)
From:
Adrian Klaver
Prev by Date:
Re: How to select avg(select max(something) from ...)
Next by Date:
PGDG PostgreSQL Debian package: Question on conditions for creation of new cluster
Previous by thread:
Re: How to select avg(select max(something) from ...)
Next by thread:
PGDG PostgreSQL Debian package: Question on conditions for creation of new cluster
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
