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


Please Help Members By Posting Answers For Below Questions

What are date and time data types in mysql?

524


how to add a new column to an existing table?

565


How do you rename a procedure in mysql?

454


Is postgresql better than mysql?

518


How to Change a users password from unix shell.

572






Can you tell what are various ways to create an index?

465


How to create a table?

556


What does blob mean in mysql?

494


How to convert character strings to numeric values?

621


How to enter numeric values as hex numbers?

537


how to Return total number of rows.

545


Is mysql a framework?

494


Where is the mysql database stored?

484


What is mysql architecture?

509


What is difference between function and procedure in mysql?

456