title: grouping id with string value instead integer SQL GROUP BY
body: <p>On Google I just found group by sum (integer value). How can I group by a string value?  For the table:</p>
  
  <pre><code>No   Place    Car 
  ---  ------   --------
  1    NY       VRM1
  1    BT       VLI
  2    NY       GAR
  3    GT       GAR
  </code></pre>
  
  <p>How can I group by 'No'?  I tried:</p>
  
  <pre><code>SELECT No, place, Car 
  FROM  APPEL
  GROUP BY No, Place, Car
  </code></pre>
  
  <p>But it didn't work.</p>
  
  <p>I want to have a table like this</p>
  
  <pre><code>No   Place    Car 
  ---  ------   --------
  1    NY,BT    VRM1,VLI
  2    NY       GAR
  3    GT       GAR
  </code></pre>