title: How to concatenate multiple rows inside a single row in SQL?
body: <p>How do I concatenate multiple rows into a single row using SQL? My database is DB2</p>
  
  <pre><code>TableFoo
   -------
   Id      Name
   1       Apples
   1       Tomatoes
   1       Potatoes
   2       Banana
   2       Peach
  </code></pre>
  
  <p>I want something like </p>
  
  <pre><code>ID       FruitsAvailable
  -------------------------
   1       Apples, Tomatoes, Potatoes
  </code></pre>