查询添加下一行的同一列

Question

我需要一个可以像这样求和的查询（上一行与当前行）

1  1
2  3
3  5
4  7
5  9

我想要 row1.MoneyPaid + row2.MoneyPaid, row2.MoneyPaid + row3.MoneyPaid,row3.MoneyPaid + row4.MoneyPaid

Answer 1

试试这个：

  SELECT m1.moneypaid, 
   ( SELECT TOP 1 m2.moneypaid 
     FROM @Money m2 
     WHERE m2.id <m1.id  
     ORDER BY m2.id  DESC
   ) AS Prev_Value
   ,m1.moneypaid + ( SELECT TOP 1 m2.moneypaid 
     FROM @Money m2 
     WHERE m2.id <m1.id  
     ORDER BY m2.id  DESC
   )