wmsys.concat()是通过“,”来将查询的多个值合并的,例如
SELECT wmsys.wm_concat(ename) FROM emp WHERE deptno = 10;
SELECT empno, wmsys.wm_concat(ename) OVER( ORDER BY empno,sal) FROM emp WHERE deptno = 10;
SELECT empno,wmsys.wm_concat(ename) OVER(PARTITION BY deptno) FROM emp;
效果图一运行就知道了
SELECT wmsys.wm_concat(ename) FROM emp WHERE deptno = 10;
SELECT empno, wmsys.wm_concat(ename) OVER( ORDER BY empno,sal) FROM emp WHERE deptno = 10;
SELECT empno,wmsys.wm_concat(ename) OVER(PARTITION BY deptno) FROM emp;
效果图一运行就知道了