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 ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / bibinsami3
i Will give 3 pts to them who find the answer with out
reffering any Documets.. :)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
What are mysql queries?
How do stored procedures work?
What are the features of mysql?
What are the features of Stored Procedures in MYSQL?
Is mysql a free database?
How do I connect to mysql database?
How many queries can mysql handle?
what is the difference between MyIsam and InnoDb engine?
How to get a list of all tables in a database?
Explain the difference between procedure and function in mysql?
How we can get the current date in mysql?
List the different types of normalization?