Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
concat rows within a group?
Migrateduser
<p>Hi,</p>
<p> </p>
<p>Does Birt have a functionality of concatenating multiple rows within a group? I am looking for something similar to the following mysql syntax</p>
<p> </p>
<p>Also, I want to know which one would be more efficient in performance?</p>
<pre class="_prettyXprint">
SELECT person_id, GROUP_CONCAT(hobbies SEPARATOR ', ')
FROM peoples_hobbies GROUP BY person_id</pre>
<p>Regards</p>
<p>Arif</p>
Find more posts tagged with
Comments
There are no comments yet