Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Write a program using the select statement, while loop.

962


How does mysql clustering work?

970


How do you determine the location of mysql data directory?

983


What are the column comparisons operators?

1297


What are stored procedures and functions?

956


Can you tell few best practices to be followed for optimization in sql?

975


Do you need a license for mysql?

987


Do while loop in mysql procedure?

1118


What are Heap tables?

1639


How internally data stores in MyISAM and INNODB table types?

2798


What is the function of mysqldump?

1123


How do I optimize a selected query in mysql?

976


What is the difference between unix timestamps and mysql timestamps?

1059


How to get help information from the server?

1110


How does mysql store data?

981