title: Comma separated values with all rows from a table
body: <p>I have a Services table with three columns.</p>
  
  <p>Service </p>
  
  <pre><code>sr_id lang alias
  1     EN    A
  1     PA    B
  1     HI    C
  2     EN    D
  2     HI    E
  </code></pre>
  
  <p>Now, I want to output with each service id, lang and alias column will be concatenation of alias for a service. </p>
  
  <p>Sample Output -</p>
  
  <pre><code>SR_ID   lang   alias
  1       EN     A,B,C
  1       PA     A,B,C
  1       HI     A,B,C
  2       EN     D,E
  2       HI     D,E
  </code></pre>
  
  <p>How can I do that with PostgreSQL 9.4?</p>