title: DB2 SQL: Grouping records with same id in result?
body: <p>if I have a table with 2 columns</p>
  
  <pre><code>text | id
  ---------
  aaa  |  1
  bbb  |  1
  eee  |  1
  mmm  |  2
  zzz  |  2
  ...
  </code></pre>
  
  <p>Is it possible to write a query which groups by id and outputs the following result:</p>
  
  <pre><code>id | text
  ------------------
   1 | aaa, bbb, eee
   2 | mmm, zzz
  ...
  </code></pre>
  
  <p>Thanks!</p>