Add the last two columns values...

Question

Hi I have a table in which I have two columns Id and Value and I want the output like Sum (add last two columns). Id Value Sum 1 10 10 2 20 30 3 30 50 4 40 70 5 50 90 Thanks & Regards: Anurag Singh

Manoj Bhoir · Answer

Hi Anurag Please check my Reply. It will give you exact output you want.

Upendra Pratap Shahi · Answer

Run below query- CREATE TABLE tableName ( id INT IDENTITY(11) columnOfNumbers int ) INSERT INTO tableName SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 10 UNION SELECT 12 WITH tblDifference AS ( SELECT ROW_NUMBER() OVER(ORDER BY id) AS RowNumber columnOfNumbers FROM tableName ) SELECT cur.columnOfNumbers cur.columnOfNumbers + previous.columnOfNumbers FROM tblDifference cur LEFT OUTER JOIN tblDifference previous ON cur.RowNumber = previous.RowNumber + 1

Manoj Bhoir · Answer

Hi Anurag Try this query : WITH GetSum AS ( SELECT ROW_NUMBER() OVER(ORDER BY id) AS RowNumber value FROM TableName ) SELECT cur.value ISNULL(cur.value + previous.valuecur.value) FROM GetSum cur LEFT OUTER JOIN GetSum previous ON cur.RowNumber = previous.RowNumber + 1 Replace TableName with your Table Name.

Rajeesh Menoth · Answer

Hi Check this demo for your question : http://sqlfiddle.com/#!3/ad6e5/11 or WITH SumDetails AS ( SELECT ROW_NUMBER() OVER(ORDER BY id) AS RowNumber columnOfNumbers FROM tableName ) SELECT cur.columnOfNumbers cur.columnOfNumbers + previous.columnOfNumbers FROM SumDetails cur LEFT OUTER JOIN SumDetails previous ON cur.RowNumber = previous.RowNumber + 1

Pankaj Kumar Choudhary · Answer

Hello @Anurag you can try this method SELECT mt.idmt.value  ISNULL( mt.value+mt1.valuemt.value) AS count FROM My_Tab mt LEFT OUTER JOIN My_Tab mt1 ON mt.id=mt1.id +1

Najjaf Shuja · Answer

SELECT ID VALUE (ID + VALUE) AS SUM FROM TABLENAME

Upendra Pratap Shahi · Answer

Hello Anurag Try my query demo.

Manoj Bhoir · Answer

Welcome Anurag.

Anurag Singh · Answer

Thanks Manoj Your query is working as expected. Anurag Singh

Khan Abrar Ahmed · Answer

Hi try isnull with 0 declare @tableName as table ( id INT  value int ) INSERT INTO @tableName values (110)(220)(330)(440)(550); WITH tblDifference AS ( SELECT idROW_NUMBER() OVER(ORDER BY id) AS RowNumber value FROM @tableName ) SELECT cur.idcur.value cur.value + isnull(previous.value0) as Sum FROM tblDifference cur LEFT OUTER JOIN tblDifference previous ON cur.RowNumber = previous.RowNumber + 1;

Upendra Pratap Shahi · Answer

Kindly write your query accordingly.

Rajeesh Menoth · Answer

Hi You can use Case statement in ur query.putt 0 or any other value for Null value.. Case in sql Example : http://www.aspdotnet-suresh.com/2012/07/query-to-use-case-statement-in-sql.html Another example : http://stackoverflow.com/questions/17869227/sql-server-case-statement-when-is-null

Anurag Singh · Answer

Thanks But this is showing null in first column. I don't want null value anywhere. In first column there should be the value of first column. Anurag