方法)SUM()OVER()
SELECT emp_no, salary, SUM(salary)over(ORDER BY emp_no) FROM salaries WHERE to_date = '9999-01-01';求累计和/汇总 语句结构:SUM( 列名 )OVER( ORDER BY 列名)
SELECT emp_no, salary, SUM(salary)over(ORDER BY emp_no) FROM salaries WHERE to_date = '9999-01-01';求累计和/汇总 语句结构:SUM( 列名 )OVER( ORDER BY 列名)