Search Postgresql Archives

Generating subtotal reports direct from SQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




I'm hoping there's a real easy way of doing this that I'm just missing:

Given a Select statement such as:

Select ID, code, amount from foo where code < 10;

that gives me a table like this:

ID	code		amount
_____________________________________
1	4		20
2	3		10
3	4		15
4	2		10
5	3		9
6	3		8

I want to generate a report table like the following (group by code):

ID	code		amount
_____________________________________
4	2		10
	2		10
2	3		10
5	3		9
6	3		8
	3		27
1	4		20
3	4		15
	4		35
			72

Such that the final table has additional subtotal rows with the aggregate sum of the amounts. I'm thinking I can generate two tables and merge them, but is there an easier way using a fancy Select statement?

-Owen

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux