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

select emp_no,salary,
sum(salary) over (order by emp_no asc rows between unbounded preceding and current row) running_total
from(
    select emp_no,salary
    from salaries
    where to_date='9999-01-01'
) t