| From: | "Don Soledad" <avsoledadjr(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | columnar format |
| Date: | 2003-07-02 02:42:58 |
| Message-ID: | Law10-F105aqngjCSml00005bb8@hotmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
good day!
i would like to ask for the sql statement to the output:
ITEM DESC Jan Feb Mar Apr ... Sep Total
xxxxxxxxxx 999 999 999 999 ... 999 9,999
where "Jan" column is sum of all "x" items purchased on Jan, "Feb" column as
sum of Feb purchases, and so on up to "Sep", and "Total" as the total from
"Jan" to "Sep" (as in the case here). the numbers may/may not be formatted,
and the period varies, depending on the range.
your help will be much appreciated.
thanks!
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Man | 2003-07-02 03:17:22 | Timeout for lock table |
| Previous Message | Joe Conway | 2003-07-02 02:25:37 | Re: passing a record as a function argument in pl/pgsql |