sql_interview_moving_sum

-- moving sum (cumulative sum using analytical function)

SELECT
employee_id,
salary,SUM(salary) OVER(partition BY department_id ORDER BY employee_id) AS cume_sum,
department_id
FROM hr.employees;