select s1.emp_no,s1.salary,
(select sum(s2.salary) from salaries as s2
where s2.emp_no<=s1.emp_no and s2.to_date = '9999-01-01') as running_total
from salaries as s1
where s1.to_date = '9999-01-01'
题目解答注意思考方式select s1.emp_no,s1.salary,(select sum(s2.salary) from salaries as s2 where s2.emp_no<=s1.emp_no and s2.to_date = '9999-01-01') as running_totalfrom salaries as s1where s1.to_date = '9999-01-01'