本文共 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 ?????????????????????????????
  
   
  
?????????????????????????????????????????
  
   
  
??????????????????????????????????????