ORA-30486: invalid window aggregation group in the window specification

文档解释

ORA-30486: invalid window aggregation group in the window specification

Cause: If the window specification is specified using RANGE option and there are multiple ORDER BY expressions, then the aggregation group cannot contain any expression (It can only have CURRENT ROW, UNBOUNDED PRECEDING, or UNBOUNDED FOLLOWING). First end point (bound) cannot be UNBOUNDED FOLLOWING and second end point cannot be UNBOUNDED PRECEDING. If the first end point is CURRENT ROW, then second end point can only be CURRENT ROW or /UNBOUNDED FOLLOWING. If the first end point is FOLLOWING, then second end point can only be /UNBOUNDED FOLLOWING.

Action: None

。

这是一个Oracle数据库的错误，它的意思是窗口函数的窗口组化语句有错误，根据官方解释，当试图使用窗口聚合时发生该错误，这是因为在窗口聚合中，窗口组规范语句的指定不正确。

常见案例

一般处理方法及步骤

1.检查窗口聚合中使用的语句，确保它们正确指定了窗口组规范；

2.在窗口聚合函数使用over子句，以避免出现缺少over子句的情况；

3.检查窗口聚合的窗口组规范，如果存在任何不合理的情况（例如Unbounded Preceding和Unbounded Following），请更正规范；

4.遵循Oracle对窗口组规范语句定义的相关文档正确构造语句，并在必要时运行窗口聚合函数。