摘要:
demo场景,以oracle自带库中的表emp为例: select ename,deptno from emp order by deptno;ENAMEDEPTNOCLARK10KING10MILLER10SMITH20ADAMS20FORD20SCOTT20JONES20ALLEN30BLAKE30MARTIN30JAMES30TURNER30WARD30现在想要将同一部门的人给合并成一行记录,如何做呢?如下:ENAMEDEPTNOCLARK,KING,MILLER10ADAMS,FORD,JONES,SCOTT,SMITH20ALLEN,BLAKE,JAMES,MARTIN,TURN.. 阅读全文