title: concat multiple rows in one field
body: <p>I have table Test</p>
  
  <pre><code>sso     ID
  -------------
  1234    XV
  1235    PL17
  1234    PL17
  1239    XV
  </code></pre>
  
  <p>I'm trying to concatenate all IDs having same sso. I have developed the output using <code>GROUP_CONCAT</code> function.</p>
  
  <p>Here is the query</p>
  
  <pre><code>SELECT sso, GROUP_CONCAT(ID) FROM samesso GROUP BY sso
  </code></pre>
  
  <p>But I want to do this without function. </p>
  
  <p>Can I have any syggestions or ideas to do this ?</p>