Hi W dniu 29.07.2013 14:28, un_spoken pisze: > 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. >
Select ID, list(value, ', ') from aTable group by ID should do the trick... Default separator is ',' when you need something different (like ', ') then pass it as a second parameter in list function... HTH Marcin
