SELECT emp_no,salary,sum(salary)over(order by emp_no) running_total
FROM salaries
WHERE to_date='9999-01-01'