SELECT deptno, wm_concat(ename) FROM emp GROUP BY deptno;
本文共 700 字,大约阅读时间需要 2 分钟。
SELECT deptno, wm_concat(ename) FROM emp GROUP BY deptno;
?????????????????
?????????????? GROUP BY ? wm_concat ?????????????????????????? SQL ???
SELECT deptno, wm_concat(ename) FROM emp GROUP BY deptno;?????????????????? GROUP BY deptno ???????????????????????????????
?????????
?????????????????????????????????????????????????????????
????????
? emp ???? deptno ????????????????????????????????????
?????? wm_concat ??
?? wm_concat ?????????????????? empno ?????????????????????????????
?????????????????????????????????????????
??????????????????????????????????????
转载地址:http://eapfk.baihongyu.com/