分析函数
我只是个看客
这个作者很懒,什么都没留下…
展开
-
sum() over()
SQL> select deptno,empno,sal,sum(sal) over (order by sal) from emp order by 3; DEPTNO EMPNO SAL SUM(SAL)OVER(ORDERBYSAL)---------- ---------- ---------- ------------------------原创 2013-11-15 15:23:18 · 540 阅读 · 0 评论 -
dense_rank() over();
select ename, sal, dense_rank( ) over (order by sal desc) dr from emp ;原创 2013-11-20 16:32:44 · 845 阅读 · 0 评论 -
lead() over();lag() over()
SQL> select deptno,ename,sal,lead(sal) over (order by sal) next_val from emp; DEPTNO ENAME SAL NEXT_VAL---------- ---------- ---------- ---------- 20 SMITH 800原创 2013-11-17 20:33:48 · 1044 阅读 · 0 评论 -
行转列、列转行(sys_connect_by_path,row_number() over,count(*) over),wmsys.wm_concat
SQL> select deptno, 2 sys_connect_by_path(ename,',') emps 3 from ( 4 select deptno, 5 ename, 6 row_number() over 7 (partition by deptno原创 2013-11-14 16:54:53 · 1175 阅读 · 0 评论