SELECT employee_id, emp_name, dept_name, salary,
       SUM(salary) OVER (PARTITION BY dept_name
                             ORDER BY salary DESC
                         ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
                        ) rows_value,
       SUM(salary) OVER (PARTITION BY dept_name
                             ORDER BY salary DESC
                         RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
                        ) range_value
 FROM emp_hierarchy
WHERE dept_name IN ('IT', 'Finance')
ORDER BY 3, 4 DESC;