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

What is the query to display top 20 rows?

1021

What are procedures in mysql?

953

Which is better mysql or mssql?

926

How to create a new table by selecting rows from another table in mysql?

992

How set mysql root password?

922

What are the purposes of using enum and set data types?

939

In mysql, what is joins? Explain

971

What is mysql command line?

1059

What is the difference between database and table?

1009

What is datatype in mysql?

950

What is federated tables in mysql?

912

Where the database is stored in mysql?

969

What is the latest mysql?

958

Is mysql free download?

854

How to delete an existing column in a table?

952