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 ?
- 4 Answers
- 5907 Views
- I also Faced
- E-Mail Answers
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
Is foreign key indexed mysql?
What is the limit of mysql database?
What port is mysql running on?
What is the difference between having and where clause in mysql? Explain
What are federated tables?
What is blob storage?
How do I change mysql password?
What is mysqli procedural?
What does mysqli_fetch_assoc do?
How do I find the database name in mysql?
What's the difference between mysql and sql server?
Does mysql use sql?
How can you take the backup and restore a mysql database using php?
What is mysql installer?
What is longblob in mysql?
