题解 | 统计salary的累计和running_total

select emp_no,salary,SUM(salary) OVER (ORDER BY emp_no ) AS running_total
FROM salaries
WHERE to_date = "9999-01-01"

查询所有当前在职员工的最新薪资，并按员工编号（emp_no）升序计算 “包含当前员工的累计薪资和”

SUM(salary) OVER (ORDER BY emp_no ) AS running_total

在不分组的情况下，按指定顺序计算累计和