select emp_no,salary,sum(salary) over (order by emp_no)
from salaries
where to_date = '9999-01-01'
-- sum(a) over (order by b) 的含义是:按照b列排序,将a依次相加
-- 1 1
-- 2 1+2=3
-- 3 1+2+3=6
select emp_no,salary,sum(salary) over (order by emp_no)
from salaries
where to_date = '9999-01-01'
-- sum(a) over (order by b) 的含义是:按照b列排序,将a依次相加
-- 1 1
-- 2 1+2=3
-- 3 1+2+3=6