在同一行求累计数,可使用聚集函数作为窗口函数
统计salary的累计和running_total
http://www.nowcoder.com/questionTerminal/58824cd644ea47d7b2b670c506a159a6
select emp_no ,salary ,sum(salary)over(order by emp_no)as running_total from salaries where to_date = '9999-01-01';
统计salary的累计和running_total
http://www.nowcoder.com/questionTerminal/58824cd644ea47d7b2b670c506a159a6
select emp_no ,salary ,sum(salary)over(order by emp_no)as running_total from salaries where to_date = '9999-01-01';
相关推荐