let ff your table...
try this:
select
a.id,
a.date,
a.hours,
(select sum(b.hours)
from ff as b
where a.id = b.id
group by b.id
) as a
from ff as a;
bye,
Luca
Henry Ortega ha scritto:
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.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
|
