select emp_no, salary
, sum(salary) over(order by emp_no) as running_total
from salaries
where to_date = '9999-01-01'
select emp_no, salary
, sum(salary) over(order by emp_no) as running_total
from salaries
where to_date = '9999-01-01'
牛客博客，记录你的成长
京公网安备 11010502036488号