title: LISTAGG or WM_CONCAT in Netezza
body: <p>Any replacement or quick solution in NETEZZA for the Oracle function LISTAGG or WM_CONCAT ?</p>
  
  <p>SELECT deptno, LISTAGG(ename, ',') WITHIN GROUP (ORDER BY ename) AS employee
  FROM   emp
  GROUP BY deptno;</p>
  
  <pre><code>DEPTNO EMPLOYEE
  </code></pre>
  
  <hr>
  
  <pre><code>    10 JOHN,MICHEL,SAM
      20 PHILIP,FORD,SCOT,SUNNY,JOSEPH
      30 ALLEN,RUBY,BETTY,MARTIN,LEON,FRANK
  </code></pre>
  
  <p>Thanks.</p>