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
6460 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

How do I restore a mysql database dump file in linux?

921

What is the purpose of mysql database?

877

How to include numeric values in sql statements?

946

how to connect a php script with the mysql database?

984

What is mysql url?

826

What are the advantages of mysql?

935

What is maximum table size in mysql?

894

How do I select a database in mysql workbench?

944

What is the difference between procedure and function in mysql?

957

How much does mysql cost?

849

Can you tell what are various ways to create an index?

819

How do I connect to a database in mysql workbench?

971

What is sql in mysql?

985

How many groups of data types?

929

What is normalization and list the different types of normalization?

911