sql-server - SQL Server 错误 : 'BETWEEN ... FOLLOWING AND CURRENT ROW' is not a valid window frame and cannot be used with the OVER clause. '？

Question

我试图将 3 个月的净值与 1 个月的净值相加。编码

SELECT [CMONTH]
      ,[ID]
      ,[NET_VALUE_1M]
      ,SUM(CAST([NET_VALUE_1M] as float)) OVER 
          (PARTITION BY [ID] ORDER BY [CMONTH] 
             ROWS BETWEEN 3 FOLLOWING AND CURRENT ROW) as 'NET_VALUE_3M'   
  FROM [Channel_AGG]

正在触发错误

Msg 4193, Level 16, State 4, Line 2
'BETWEEN ... FOLLOWING AND CURRENT ROW' is not a valid window frame 
and cannot be used with the OVER clause.

为什么，是什么导致了这种情况以及如何解决？

Answer 1

你需要使用

ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING

The upper bound cannot be smaller than the lower bound.