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
On 2/18/25 12:56, dfgpostgres wrote:
Hi:
psql 15.3
I have a table with sets of observations, each set sharing an id.
I want to get the average of the max of each set.
id | val
---
1 5.0
1 4.3
1 3.8
2 4.8
2 6.0
2 2.9
3 4.1
3 4.4
3 8.0
So I want the
On Wed, 19 Feb 2025 at 09:56, dfgpostgres wrote:
> So I want the avg of the max of the set where id=1 (5.0), where id=2 (6.0),
> where id=3 (8.0) ~= 6.33...
>
> I tried this...
>
> select
> avg(x.maxsz)
>from
> dvm.dvm_events d,
>
Hi:
psql 15.3
I have a table with sets of observations, each set sharing an id.
I want to get the average of the max of each set.
id | val
---
1 5.0
1 4.3
1 3.8
2 4.8
2 6.0
2 2.9
3 4.1
3 4.4
3 8.0
So I want the avg of the max of the set where id=1 (5
