tsql - 每 4 行重叠分组

Question

抱歉，标题含糊不清，但我不确定如何表述这个问题。我想做的是每 4 条记录对一列进行分组求和，但分组会重叠

 Game       Strikeouts
    1.                 25
    2.                 10
    3.                 10
    4.                 11
    5.                 16

显示第一组是第 1-4 场比赛，总和是 56，第二组是 2-5，太阳队是 47，依此类推直到最后一个记录。

Answer 1

另一种选择

Select Game
      ,Strikeouts = sum(Strikeouts) over (Order By Game ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING ) 
 From  YourTable
 Order By Game

返回

Game    Strikeouts
1       56
2       47
3       37
4       27
5       16