Right, this would need an aggregate function of some kind, probably flavor dependent, or possibly a stored procedure using procedural SQL. Sqlite has one, I forget the name currently...and also with sqlite you can always write your own in C if you so desire :)
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Chris Peterson Sent: Thursday, June 18, 2009 6:06 PM To: [email protected] Subject: [Trac] Re: Concatenate multiple row data into single row Actually a join would not help here, from what I have looked at, you would need to use a stored procedure to create this type of result, or use some oracle-only function to do that =) Chris On 6/18/09 6:45 PM, "Erik Bray" <[email protected]> wrote: > > On Thu, Jun 18, 2009 at 2:06 AM, rishikesh<[email protected]> wrote: >> >> I have a sub-query which selects some rows from a table. I want to >> concatenate these rows in a single row. >> >> Example: >> >> Column1 >> Row1 >> Row2 >> Row3 >> Row4 >> >> I want this result as: >> Column1 >> Row1Row2Row3Row4 >> >> Looking for a solution with "Single" query > > Well, your example is too abstract to provide an actual query, but you > would have to use JOINs to do this. > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
