title: How to concatenate multiple rows' fields in a sap hana table
body: <p>I use SAP-HANA database. I have a simple 2 column table whose columns are id, name. The rows are these:</p>
  
  <pre><code>1 - tom
  1 - harry
  1 - jack
  2 - larry
  </code></pre>
  
  <p>I would like to group the rows by the id, and concatenate the names into a field, and thus obtain this:</p>
  
  <pre><code>1 - tom, harry, jack
  2 - larry
  </code></pre>
  
  <p>Can you please tell me how we can perform this operation in sap-hana? Thanks in advance.</p>