Subject | Does function for concatenating values from one column exist? |
---|---|
Author | un_spoken |
Post date | 2013-07-29T12:28:58Z |
Hi guys,
I think I saw somewhere a built-in function which allows me to convert this resultset:
ID, VALUE
1 2
1 5
1 7
5 9
5 8
7 3
7 5
into this:
ID, VALUE
1 2, 5, 7
5 8, 9
7 3, 5
I know I can do it myself but I do not want to reinvent the well. Could you help me on this? I can not find any info about such function but I could swear I saw it a year ago or so.
Regards.
I think I saw somewhere a built-in function which allows me to convert this resultset:
ID, VALUE
1 2
1 5
1 7
5 9
5 8
7 3
7 5
into this:
ID, VALUE
1 2, 5, 7
5 8, 9
7 3, 5
I know I can do it myself but I do not want to reinvent the well. Could you help me on this? I can not find any info about such function but I could swear I saw it a year ago or so.
Regards.