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 ?
- 4 Answers
- 5346 Views
- I also Faced
- E-Mail Answers
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
In which year mysql created?
What is a procedure example?
What are the 3 main types of search queries?
What is the innodb in mysql?
How do I view mysql logs?
Is foreign key indexed mysql?
What is triggers?
What are the advantages of myisam over innodb?
Does adding an index lock a table?
What is data types in mysql?
Write a command with which mysql table can be repaired
Transactions are used to treat sets of SQL statements atomically. State Whether True or False?
Which is better mysql or mssql?
How to shutdown mysql server?
What is the difference between procedure and function in mysql?
