首页 > 代码库 > listagg( ) within group ( order by ) 与 wm_concat
listagg( ) within group ( order by ) 与 wm_concat
listagg( ) within group ( order by ) 与 wm_concat--oracle 11g 及以后适合 最好select spbywslid,listagg(xm,‘,‘) within group (order by spbywslid) col_name from tpg_jtcyqk group by spbywslid;--oracle 10g 及以前版本用select spbywslid,wm_concat(xm)xm from tpg_jtcyqk group by spbywslid;select deptno,wm_concat(ename)name,count(*)rs from emp group by deptnoselect deptno,listagg(ename,‘,‘) within group (order by ename ) aa from emp group by deptnoselect deptno,listagg(ename,‘,‘) within group (order by ename ) aa,count(*)bb from emp group by deptno
listagg( ) within group ( order by ) 与 wm_concat
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。