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