题解 | 60#统计salary的累计和running_total#

select emp_no,salary,sum(salary) over (order by emp_no) running_total
from salaries
where to_date='9999-01-01'

思路：熟悉窗口函数的使用