Show Output In Table

Question

I am very new in SQL and i need a output like this. I have a table

Name    Price 
----------------
A        10    
B        20   
C        30

and output should be

Name    Price    running  
--------------------------
A       10          10    
B       20          30  
C       30          60

Please Tell me the Query for this output.

http://stackoverflow.com/questions/2120544/how-to-get-cumulative-sum — Vikdor, Jan 07 '13 at 05:21
This is a very good article regarding the Running Total problem. http://www.sqlservercentral.com/articles/T-SQL/68467/. Also, if you were using SQL Server 2012, there is another solution you could use that involves `ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW` — MarkD, Jan 07 '13 at 05:35

Vishal Suthar · Accepted Answer · 2013-01-07T05:29:54.503

1

You need this:

select t1.Name, t1.Price,
    SUM(t2.Price) as running
    from your_table t1 inner join your_table t2
on t1.Name >= t2.Name
group by t1.Name, t1.Price
order by t1.Name

Demo SQLFiddle

edited Jan 07 '13 at 05:29

answered Jan 07 '13 at 05:24

Vishal Suthar

17,013
3
59
105

but i have only single table – Ankur Gupta Jan 07 '13 at 05:25
They both are the same table..@user1648801 – Vishal Suthar Jan 07 '13 at 05:29
1

Just be aware that some collations treat characters differently so it may not always be A < B < C etc. In most cases, this is not a problem. – Jan 07 '13 at 05:47

Show Output In Table

1 Answers1

Demo SQLFiddle