For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
For a query with multiple window functions, create a separate WINDOW clause and then reference it in each OVER
SELECT sum(salary) OVER w, avg(salary) OVER w
FROM empsal
WINDOW w AS (PARTITION BY depname ORDER BY salary DESC);