Oracle Error ORA-30483: window functions are not allowed here

Oracle Error Message

ORA-30483: window functions are not allowed here

Reason for the Error

Window functions are allowed only in the SELECT list of a query. And, window function cannot be an argument to another window or group function.

Solution

None