Re: Select maximum amoung grouped sums - Mailing list pgsql-novice

--- Jan Danielsson <jan.m.danielsson@gmail.com> wrote:
>
> ----------------------
> select date_part('year', dt) as year, date_part('week', dt) as week,
>     sum(amount) as asum
> from transactions
> group by year,week
  having asum = (
                 select max(A.weeksum)
                 from
                     (
                      select sum(amount) as weeksum
                      from transactions
                      group by date_trunc('week', dt)
                     ) A
                )
> order by year,week;
> ----------------------


This should do what you want, but I expect that there is a better answer.

Regards,
Richard Broersma Jr.