Quantcast

how to achieve string concateneation as an aggregate

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

how to achieve string concateneation as an aggregate

Tzvika Barenholz
Hi all

say I have a table with an int and a varchar, and the values are
something like this:


1   boo
2   loo
3   foo
2   moo


i want to get the concatenation of the strings group by the int, i.e.
the result would be:

1 boo
2 loomoo
3 foo


is there a way to do this ?


thx in advance
Tzvika


-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
Hsqldb-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
Loading...