日期:2014-05-17 浏览次数:20977 次
SQL> select deptno, wm_concat(ename) wm from emp where deptno=10 group by deptno; DEPTNO WM ---------- -------------------------------------------------- 10 Clark,Miller,King
------解决方案--------------------
select deptno, wm_concat(ename) from emp group by deptno having deptno=10;