oracle wm_concat函数列转行分组函数

2024-08-25 08:16:55

（1）select mark, wm_concat(status) from DISSENT_INFO t GROUP BY mark;

查出来的数据

mark status

222 1007,1006
333 1008,1008
444 1008

（2）

SQL> select deptno,listagg(ename,',')within group(order by sal)name from emp group by deptno;

    DEPTNO NAME

---------- ----------------------------------------------------------------------------------------------------

    10 MILLER,CLARK,KING

    20 SMITH,ADAMS,JONES,FORD,SCOTT

    30 JAMES,MARTIN,WARD,TURNER,ALLEN,BLAKE

最新文章

热门文章