题解 | #统计salary的累计和running_total#

select s1.emp_no,s1.salary,sum(s2.salary) as running_total from salaries s1,salaries s2 where s1.emp_no >= s2.emp_no and s1.to_date = '9999-01-01' and s2.to_date = '9999-01-01' group by s1.emp_no,s1.salary

查询满足s1.emp_no >= s2.emp_no并且to_date = '9999-01-01'的s2薪水总数