2000年
-
编辑 删除
Expert 101 Oracle 分析函数
一、 一个查询例子：[php]SQL> break on deptno skip 1SQL> select ename,deptno,sal,2 sum(sal) over (order by deptno,ename) running_total,3 sum(sal) over (partition by deptno order by ename) department_total,4 row_number() over (partition by deptno order by ename) seq5 from emp;[/php][@more@][php]ENAME DEPTNO SAL RUNNING_TOTAL DEPARTMENT_TOTAL SEQ ---------- ---------- ---------- ------------- ---------------- ----------CLARK 10 2450 2450 2450 1KING 5000 7450 7450 2MILLER 1300 8750 8750 3FORD
