title: group records bases on one column name in data set and display all the values corresponding to the column for which records are grouped in SQL
body: <p>For example, if I have a data-set as below</p>
  
  <pre><code>ID ITEM
  1   A
  2   B
  3   C
  1   B
  1   C
  2   A
  </code></pre>
  
  <p>then need a sql query which gives output as below:</p>
  
  <pre><code>ID  ITEM
  1    A, B, C
  2    B, A
  3    C
  </code></pre>
  
  <p>That is how to group based on ID and display all the values pertaining to another column attributes in SQL.</p>