| From: | Henry Ortega <juandelacruz(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | sum but not grouped by? |
| Date: | 2005-08-05 16:28:24 |
| Message-ID: | 2bffcc33050805092862a01b93@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mischa Sandberg | 2005-08-05 16:47:55 | Re: sum but not grouped by? |
| Previous Message | Rob Kirkbride | 2005-08-05 10:49:18 | Re: 'select where' using multiple columns. |