题解 | 统计salary的累计和running_total
统计salary的累计和running_total
https://www.nowcoder.com/practice/58824cd644ea47d7b2b670c506a159a6
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
在不分组的情况下，按指定顺序计算累计和
投递巨人网络等公司6个岗位
，养生