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 ?
Answer Posted / 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 |
Post New Answer View All Answers
Write a program using the select statement, while loop.
How does mysql clustering work?
How do you determine the location of mysql data directory?
What are the column comparisons operators?
What are stored procedures and functions?
Can you tell few best practices to be followed for optimization in sql?
Do you need a license for mysql?
Do while loop in mysql procedure?
What are Heap tables?
How internally data stores in MyISAM and INNODB table types?
What is the function of mysqldump?
How do I optimize a selected query in mysql?
What is the difference between unix timestamps and mysql timestamps?
How to get help information from the server?
How does mysql store data?