List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:May 3 2010 5:10am
Subject:Re: How to Get Running Totals.
View as plain text  
 >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 <jblanchard@stripped> wrote:
>
>
> From: Jay Blanchard <jblanchard@stripped>
> Subject: RE: Pivot Query in
> To: "VR Venugopal Rao" <venugopal.vellore@stripped>, "MySQL"
> <mysql@stripped>
> 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=1
>
>
>
>
>   
> ------------------------------------------------------------------------
>
>
> 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
>
>   

Thread
Pivot Query in VR Venugopal Rao28 Apr
  • Re: Pivot Query innwood28 Apr
  • RE: Pivot Query in Jay Blanchard28 Apr
    • Re: Pivot Query inPeter Brawley28 Apr
    • Pivot Query in MySQLVR Venugopal Rao29 Apr
    • How to Get Running Totals.Venugopal Rao3 May
      • Re: How to Get Running Totals.Peter Brawley3 May