>I am trying to get running totals
See "Running sum" at http://www.artfulsoftware.com/infotree/queries.php.
PB
-----
Venugopal Rao wrote:
I am trying to get running totals for the following:
Project Code---R&D---STP--RunningTotal
1007303----------04-------04---8
1007304----------04-------04---16
I tried to follow the examples available on the site but it is giving errors.
I am using java as a middleware and mysql as back end.
I am trying ot use backend query for getting the results.
response with examples will be more helpful.
With regards,
VR Venugopal Rao
--- On Wed, 28/4/10, Jay Blanchard <jblanch...@pocket.com> wrote:
From: Jay Blanchard <jblanch...@pocket.com>
Subject: RE: Pivot Query in
To: "VR Venugopal Rao" <venugopal.vell...@cmcltd.com>, "MySQL"
<mysql@lists.mysql.com>
Date: Wednesday, 28 April, 2010, 4:57 PM
[snip]
Date, ProjectCode Building, Number of Copies
I want to get a Connsolidate Report of
Project Code R&D STP
1007304----------04-------04
(Group by Project Code)(Sumtotal Building wise).
I have tried to execute the following code :
select pcode, building, sum(ncopies) from request group by
pcode,building
It is giving the following repott
1007304--R&D--04
1007304-STP--05
Here there is a repetition of pcode,
How can I avoid this. I want to get the Building Name on top as Column
Names
and bottom I should get the Count.
[/snip]
We would need to see some of the raw data to help you but this older
article may point you in the right direction with crosstab (pivot)
queries;
http://www.evolt.org/node/26896
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=vr_v...@yahoo.co.in
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.437 / Virus Database: 271.1.1/2849 - Release Date: 05/02/10 06:27:00