5、name,sal,sum(sal)over(partitionbydeptnoorderbyename)sum1,/*表示按部门号分氏,按姓名排序并连续求和*/sum(sal)over(partitionbydeptno)sum2,/*表示部门分区,求和*/sum(sal)over(partitionbydeptnoorderbysal)sum3,/*按部门分区,按薪水排序并连续求和*/100*round(sal/sum(sal)over(),4)"bal%"fromemp结果如下: DEPTNOENAME SAL SUM1 SUM2