title: In HQL, How to get comma separated string from subquery result in select clause?
body: <p>I have a requirement to display the sub-query result as comma separated string in HQL. </p>
  
  <pre><code>select DEPARTMENT_ID, 
         (select FIRST_NAME 
            FROM EMPLOYEES 
           where DEPARTMENT_ID =90) as Employee_Names 
   FROM DEPARTMENTS 
  where DEPARTMENT_ID =90; 
  </code></pre>
  
  <p>The sub-query result in the select clause i need to show as comma separated values. </p>
  
  <p>Any help is appreciated in advance. Thanks.</p>