title: how to change this query in Hibernate? comma separated list in one column
body: <p><a href="http://i.stack.imgur.com/jTGvv.png" rel="nofollow">Previous output</a></p>
  
  <p>SQL query - </p>
  
  <pre><code>select 
       employeeid,FamilyPay,IsActive,
      stuff((
          select  ',' + u.IndividualPay
          from yourtable u
          where u.IndividualPay = IndividualPay
          order by u.IndividualPay
          for xml path('')
      ),1,1,'') as IndividualPay
  from yourtable
  group by EmployeeID,FamilyPay,IsActive
  </code></pre>
  
  <p>output :-
  <a href="http://i.stack.imgur.com/AsXEv.png" rel="nofollow">Desired output</a>
  <br>Can someone help me changing this in Hibernate query ?</p>