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 / shaik
select a.month,a.quantity,sum(b.quantity) as total from qunt
a cross join qunt b
where b.month<=a.month
group by a.month,a.quantity
order by month
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is longblob?
How do you login to MySql using Unix shell?
Why do we use mysql?
What is the use of mysqli_connect in php?
How do I update a variable in mysql?
Write command to import an mysql file?
What is a simple query?
How can we find out which auto increment was assigned on Last insert?
What are programming functions?
What is mysql architecture?
How do I setup mysql?
How do you say mysql?
How do I install mysql workbench?
What is the hostname for mysql database?
Why we use mysql database?