oracle 分析函数 视频,ORACLE分析函数实战(Analytical Functions)_PART8
--用于普通組函數
select deptno,wm_concat(ename) enames
from emp
group by deptno
order by deptno;
DEPTNO????????? ENAMES
10???????? CLARK
10???????? CLARK,KING,KING,KING
10???????? CLARK,KING,KING,KING
10???????? CLARK,KING,KING,KING
10???????? CLARK,KING,KING,KING,MILLER
20???????? ADAMS
20???????? ADAMS,FORD
20???????? ADAMS,FORD,JONES
20???????? ADAMS,FORD,JONES,SCOTT
20???????? ADAMS,FORD,JONES,SCOTT,SMITH
30???????? ALLEN
30???????? ALLEN,BLAKE
30???????? ALLEN,BLAKE,JAMES
30???????? ALLEN,BLAKE,JAMES,MARTIN
30???????? ALLEN,BLAKE,JAMES,MARTIN,TURNER
30???????? ALLEN,BLAKE,JAMES,MARTIN,TURNER,WARD
--用于分析函數
select deptno,wm_concat(ename)over(partition by deptno order by ename)
from emp
DEPTNO????????? ENAMES
10???????? CLARK
10???????? CLARK,KING,KING,KING
10???????? CLARK,KING,KING,KING
10???????? CLARK,KING,KING,KING
10???????? CLARK,KING,KING,KING,MILLER
20???????? ADAMS
20???????? ADAMS,FORD
20???????? ADAMS,FORD,JONES
20???????? ADAMS,FORD,JONES,SCOTT
20???????? ADAMS,FORD,JONES,SCOTT,SMITH
30???????? ALLEN
30???????? ALLEN,BLAKE
30???????? ALLEN,BLAKE,JAMES
30???????? ALLEN,BLAKE,JAMES,MARTIN
30???????? ALLEN,BLAKE,JAMES,MARTIN,TURNER
30???????? ALLEN,BLAKE,JAMES,MARTIN,TURNER,WARD
總結
以上是生活随笔為你收集整理的oracle 分析函数 视频,ORACLE分析函数实战(Analytical Functions)_PART8的全部內容，希望文章能夠幫你解決所遇到的問題。
- 上一篇： 英特尔® 虚拟化技术
- 下一篇： 高性能服务器一体机,速度飙升10万倍！华