title: group_concat in Informix
body: <p>Looking for a query in Informix's SQL that will simulate MySQL's <code>group_concat</code> function.</p>
  
  <p>What MySQL's <code>group_concat</code> does is it creates an enumeration of all members in the group.</p>
  
  <p>So with the data as follows:</p>
  
  <pre><code>orderid:itemName:price
        1:Paper   :10
        1:Pen     :5
        2:Sugar   :15
  </code></pre>
  
  <p>and the following query:</p>
  
  <pre><code>select group_concat(itemName), sum(price)
  from order_details
  group by orderid
  </code></pre>
  
  <p>would produce:</p>
  
  <pre><code>items    :price
  Paper,Pen:15
  Sugar    :15
  </code></pre>
  
  <p>What would be most efficient way to achieve this in Informix? Would we definitely have to use a stored procedure?</p>