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
Where the database is stored in mysql?
What is blob storage?
What is the limitation of mysql?
What are the drivers in MySQL?
How to show all tables with 'mysql'?
What are the different types of triggers in mysql?
Can we write pl sql mysql?
What is a mysql view?
How do I view tables in mysql workbench?
How can you take the backup and restore a mysql database using php?
How to enter microseconds in sql statements?
How to add a new column to an existing table in mysql?
What is user in mysql?
How can I compare two mysql databases?
Create table employee (eno int(2),ename varchar(10)) ?