I have a table like this tblData (month int,Qty int) and i am inserting three

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 / bibinsami3

4 Answers
6516 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table ..

Answer / 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

I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table ..

Answer / 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

I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table ..

Answer / sandhirasegaran

SELECT tbl1.month,tbl1.Qty,( SELECT SUM(tbl2.Qty) FROM
tblData AS tbl2 WHERE tbl1.month >= tbl2.month ) FROM
tblData AS tbl1

Is This Answer Correct ?

1 Yes

0 No

I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table ..

Answer / 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

More MySQL Interview Questions

What mysql -u john -p command does?

0 Answers

Does mysql use sql?

0 Answers

What are the types of database engines available in mysql?

0 Answers

Is Mysql query is case sensitive?

0 Answers

How we get sum of column.

0 Answers

Write a program using the select statement, while loop.

0 Answers

How do I edit a trigger in mysql?

0 Answers

What is cast in mysql?

0 Answers

How many groups of data types?

0 Answers

What is table level locking in mysql?

0 Answers

The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id

2 Answers

How do I install mysql on windows 10?

0 Answers

For more MySQL Interview Questions Click Here