你即將離開本站

並前往https://stackoverflow.com/questions/11107666/nested-aggregate-functions-with-grouping-in-postgresql

Nested aggregate functions with grouping in postgresql

You need a subquery: select z, avg(sumval) from (select y, z, sum(x) as sumval from t group by y, z ) t group by z.

確定！ 回上一頁

查詢 「PostgreSQL aggregate」的人也找了：

  1. PostgreSQL aggregate
    2.
  2. PostgreSQL ARRAY_AGG
    3.
  3. PostgreSQL array
    4.
  4. PostgreSQL jsonb
    5.
  5. PostgreSQL array contains
    6.
  6. PostgreSQL stddev
    7.
  7. PostgreSQL SUM
    8.
  8. PostgreSQL GROUP BY
    9.