MIME-Version: 1.0
References: <CAAcmDX8Xs5+NbSV1UGUsj06yQpC=wYj_FOfTMZNvFe6uXDTqcw@mail.gmail.com>
 <0878c968-a3d6-4803-a5b8-3ac1eb876309@aklaver.com>
In-Reply-To: <0878c968-a3d6-4803-a5b8-3ac1eb876309@aklaver.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Tue, 18 Feb 2025 19:10:06 -0500
Message-ID: <CAKAnmm+yfxQF1c_BvB83s5tShcxNiwc0iP5Wxfy_ti2fVVRvoA@mail.gmail.com>
Subject: Re: How to select avg(select max(something) from ...)
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: dfgpostgres <dfgpostgres3@gmail.com>, pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000009d6ac9062e73964d"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmm%2ByfxQF1c_BvB83s5tShcxNiwc0iP5Wxfy_ti2fVVRvoA%40mail.gmail.com>
Precedence: bulk

--0000000000009d6ac9062e73964d
Content-Type: text/plain; charset="UTF-8"

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

--0000000000009d6ac9062e73964d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Another variation:<div><br></div><div>sel=
ect avg(max) from (select distinct max(val) over(partition by id) from myta=
ble);</div><div><br></div><div><br></div></div><div>Cheers,</div><div dir=
=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr"><div>Greg</div><div><br=
></div><div>--</div><div>Crunchy Data - <a href=3D"https://www.crunchydata.=
com" target=3D"_blank">https://www.crunchydata.com</a></div><div>Enterprise=
 Postgres Software Products &amp; Tech Support</div><div><br></div></div></=
div></div>

--0000000000009d6ac9062e73964d--