select dept.dname,wm_concat(emp.ename)
from dept,emp
where dept.deptno=emp.deptno
group by dept.dname
oracle合并列函数wm_concat
最新推荐文章于 2022-08-22 14:24:34 发布
select dept.dname,wm_concat(emp.ename)
from dept,emp
where dept.deptno=emp.deptno
group by dept.dname