- 坑:order by默认的窗口就是截至到当前行,不用再额外加了。。。
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';