How to fix the Oracle error ORA-30486: invalid window aggregation group in the window specification?

In this post, you’ll learn more about the Oracle ErrorORA-30486: invalid window aggregation group in the window specification with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error ORA-30486: invalid window aggregation group in the window specification

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.

How to fix the Error ORA-30486: invalid window aggregation group in the window specification ?

You can fix this error in Oracle by following the below steps

None