摘要: demo场景,以oracle自带库中的表emp为例: select ename,deptno from emp order by deptno;ENAMEDEPTNOCLARK10KING10MILLER10SMITH20ADAMS20FORD20SCOTT20JONES20ALLEN30BLAKE30MARTIN30JAMES30TURNER30WARD30现在想要将同一部门的人给合并成一行记录,如何做呢?如下:ENAMEDEPTNOCLARK,KING,MILLER10ADAMS,FORD,JONES,SCOTT,SMITH20ALLEN,BLAKE,JAMES,MARTIN,TURN.. 阅读全文
posted @ 2012-12-20 10:26 斌哥 阅读(685) 评论(0) 推荐(0) 编辑