Oracle Error ORA-30485: missing ORDER BY expression in the window specification

Oracle Error Message

ORA-30485: missing ORDER BY expression in the window specification

Reason for the Error

Either the ORDER BY expression is mandatory for this function, or there is an aggregation group without any ORDER by expression.

Solution

None