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 ?
- 4 Answers
- 6658 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
How do I create a new database in mysql?
How many columns can you create for an index?
How do I start mysql server?
What is blob datatype in mysql?
What is pdo connection?
What's new in mysql 8?
How would you get the current date in mysql?
Why do we write stored procedures?
What do you need to connect php to mysql?
How do I kill a mysql query?
How many groups of data types?
How to delete a trigger in mysql?
How to dump a table to a file with 'mysqldump'?
What is tee command in mysql?
How to load data files into tables with 'mysqlimport'?
