select a.month,a.Qty,sum(b.Qty) as total from tblData a cross join tblData

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 ?

Question Posted / anurag misra

4 Answers
6848 Views
I also Faced
E-Mail Answers

Answer Posted / anurag misra

select a.month,a.Qty,sum(b.Qty) as total
from tblData a cross join tblData b
where b.month<=a.month
group by a.month,a.Qty

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is triggers and how it can be used in mysql?

1017

Is mysql free software?

1016

Is number a datatype in mysql?

994

How to delete a table.

972

How to delete the repeated records from a table?

1038

What is the current version of mysql?

1019

How can I insert images into a Mysql database?

1110

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

915

How do I connect to a mysql database?

970

How do I find my mysql username and password?

1002

How would you get the current date in mysql?

1159

Explain what is mysql?

1080

Can varchar be primary key?

974

Write a program using the select statement, while loop.

962

What is full form of xampp?

1233