title: Sybase: How do I concatenate rows in sybase column
body: <p>I have a table with ID and Dept.<br></p>
  
  <p>Table is</p>
  
  <pre><code>id  dept    salary  date
  1   30      2000    8/25/2015 12:06:54.870 PM
  2   20      5500    7/12/2015 12:06:54.870 PM
  3   30      6700    11/21/2013 12:06:54.870 PM
  4   30      8900    4/16/2009 12:06:54.870 PM
  5   30      9900    6/29/2014 12:06:54.870 PM
  6   10      1120    7/3/2015 12:06:54.870 PM
  7   20      8900    4/13/2013 12:06:54.870 PM
  8   10      2400    7/23/2015 12:06:54.870 PM
  9   30      2600    8/21/2015 12:06:54.870 PM
  10  10      2999    8/3/2015 12:06:54.870 PM
  </code></pre>
  
  <p>Just need the output like this <br></p>
  
  <pre><code>Dept  ID
  30     1,3,4,5,9
  </code></pre>