SELECT tbl1.month,tbl1.Qty,( SELECT SUM(tbl2.Qty) FROM tblData AS tbl2 WHE

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 / sandhirasegaran

4 Answers
6843 Views
I also Faced
E-Mail Answers

Answer Posted / sandhirasegaran

SELECT tbl1.month,tbl1.Qty,( SELECT SUM(tbl2.Qty) FROM
tblData AS tbl2 WHERE tbl1.month >= tbl2.month ) FROM
tblData AS tbl1

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you stop an access query?

968

List data types in mysql? Explain

969

What is the usage of "i-am-a-dummy" flag in mysql?

1196

How do I assign a variable in mysql?

1052

What is sql vs mysql?

1069

What is the purpose of using timestamp data type?

974

How do I grant privileges to a user in mysql phpmyadmin?

996

What is mysql command line?

1115

How to store binary data in mysql?

1049

What are the advantages of mysql in comparison to oracle?

1066

Does adding an index lock a table?

1002

How will you export tables as an xml file in mysql?

969

How to execute mysql query in php?

967

How do I start mysql in mysql workbench?

1004

How many columns can a mysql table have?

956