Getting sum of current and next row in sql server 2008/2005

• dineshcred

  SSC Journeyman

  Points: 76

  More actions

  August 28, 2017 at 2:57 am

  #332441

  Dear Sirs

  My data is as below till 3rd columns

  Year	Month	Sumsales	Curr_Next
  2016	12	100	220
  2017	1	120	170
  2017	2	50	190
  2017	3	140	310
  2017	4	170	170

  Output is needed as per above having first three coloums as above plus last column (having addition of current and next row). Please suggest.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  August 28, 2017 at 3:01 am

  #1957043

  Without DDL I can't write the query...

  Calculate a row_number over the partition and order that you want for the sum. Do that in a CTE. Then join that to itself on the partition columns and row_number of one = (row number of the other) -1. Then you'll have the two sales as columns and you can trivially add them together.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass