Ok, this is not so relevant question. I'm just wonder if this is possible by db2 sql syntax. Let's assume I have a table as follows:
Name Hobby
Jim Flowers
Jane Karate
Jane Shooting
Jim Gardening
and if I want the result looks like:
Name Hobbies
Jim Flowers, Gardening
Jane Karate, Shooting
I've sometimes seen this done by Ms Access, but they might have used some user definied function.
Name Hobby
Jim Flowers
Jane Karate
Jane Shooting
Jim Gardening
and if I want the result looks like:
Name Hobbies
Jim Flowers, Gardening
Jane Karate, Shooting
I've sometimes seen this done by Ms Access, but they might have used some user definied function.