Re: sum but not grouped by?

Quoting Henry Ortega <juandelacruz(at)gmail(dot)com>:

> I have the ff data:
>
> id | date | hours
> AAA 07-01-2005 3
> AAA 07-02-2005 4
> BBB 07-01-2005 6
> BBB 07-02-2005 2
> BBB 07-03-2005 7
>
> Would it be possible to get the ff:
>
> id | date | hours | id_total
> AAA 07-01-2005 3 7
> AAA 07-02-2005 4 7
> BBB 07-01-2005 6 15
> BBB 07-02-2005 2 15
> BBB 07-03-2005 7 15
>
> So it's like SUM OF, but not Grouped By? Is this possible at all?
> Thank you for any help.

You're really joining two sets:

select FFDATA.id, FFDATA.date, FFDATA.hours, FFSUM.id_total
from FFDATA
join (select id, sum(hours) as id_total
from FFDATA group by id
) as FFSUM using(id)