Re: Select maximum amoung grouped sums [VASCL:A11557D9645]

Jan Danielsson wrote:
> Richard Broersma Jr wrote:
>
>> --- Jan Danielsson <jan(dot)m(dot)danielsson(at)gmail(dot)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.
>>
>
> Hmm... This gives me:
>
> ERROR: column "asum" does not exist
> LINE 5: having asum = (
>
> Any ideas?
>
>
Jan,

Try 'sum(amount)' in place of 'asum'

thanks,
cyrus