SELECT emp_no,
salary,
sum(salary) over (order by emp_no) running_total
FROM salaries
where to_date='9999-01-01'
; - 窗口函数,这里不需要分组,就不用partition by
- order by的默认就是第一行到当前行,所以不需要特意指出
rows between unbounded preceding and current row
```

SELECT emp_no,
salary,
sum(salary) over (order by emp_no) running_total
FROM salaries
where to_date='9999-01-01'
; rows between unbounded preceding
and current row
```