想吃卤蛋的候选人真的会谢

分类

题解(1)

/ 注册

全部文章（共1篇）

题解：统计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'窗口函数直接搞定

SQL

2020-10-08

145 6855