普通解法(复杂解法)
select s1.emp_no,s1.salary, (select sum(salary) from salaries as s2 where s2.emp_no<=s1.emp_no and to_date='9999-01-01' )as running_total from salaries as s1 where to_date='9999-01-01' order by s1.emp_no窗口函数解法(简单解法)
select emp_no,salary, sum(salary) over(order by emp_no) as running_total from salaries where to_date='9999-01-01'