select a.month,a.Qty,sum(b.Qty) as total from tblData a cross join tblData

I have a table like this tblData (month int,Qty int)

and i am inserting three rows in this table
1.tblData Values (1,100)
2.tblData Values (2,200)
3.tblData Values (3,300)

The Result I want is the Running total of the field Qty

that is 1 100 100
2 200 300
3 300 600

What is the Query for that ?

Question Posted / anurag misra

4 Answers
6654 Views
I also Faced
E-Mail Answers

Answer Posted / anurag misra

select a.month,a.Qty,sum(b.Qty) as total
from tblData a cross join tblData b
where b.month<=a.month
group by a.month,a.Qty

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is blob datatype in mysql?

936

Explain the storage engines in mysql?

1002

What are the 5 r's of managing behaviors?

1087

How to install mysql?

1020

How are mysql timestamps seen to a user?

1018

Is there a free mysql?

897

If you wish to encrypt the username and password using php, how will you do that?

1022

Will mysql remain free?

959

can you tell the order of sql select statement? : Mysql dba

914

How do I view mysql logs?

886

How do I restore a database in mysql workbench?

1003

Can we store pdf files in mysql?

987

Which is faster innodb or myisam?

1042

What is bigint in mysql?

916

how to display nth highest salary from a table in a mysql query? : Mysql dba

1065