oracle累积求和分析函数sum over的使用

示例1:select deptno,ename,job,sal,sum(sal) over(order by sal) he from emp;结果：20SMITHCLERK 80080030JAMESCLERK 950175020ADAMSCLERK 1100285030WARDSALESMAN 1250535030MARTINSALESMAN 1250535010MILLERCLERK 1300665030TURNERSALESMAN 1500815030ALLENSALESMAN 16009750示例2:select deptno,ename,sal,sum(sal) over(partition by deptno order by ename) he from emp;结果:10CLARK2450245010KING5000745010MILLER1300875020ADAMS1100110020FORD3000410020JONES2975707520SCOTT30001007520SMITH8001087530ALLEN1600160030BLAKE28504450