GROUP BY one field in SQL and combine a specific field of all grouped rows to one column
<p>I have a situation where I need to group SQL results by a specific field, while at the same time I need all values of a specific column of the grouped rows to be returned in one field (like so values1,value2,value3 etc)</p>

<p>example data:</p>

<pre><code>NAME id 
john 1
john 2
john 3
maria 4
maria 5
</code></pre>

<p>result I need:</p>

<pre><code>john 1,2,3
maria 4,5
</code></pre>

<p>Is this possible and how?</p>