id | value |
1 | a |
1 | c |
1 | e |
2 | b |
2 | d |
select ID,wmsys.wm_concat(Val) as Path
from test
group by ID;
---------------------------------------------------------
id | path |
1 | a,c,e |
2 | b,d |
id | value |
1 | a |
1 | c |
1 | e |
2 | b |
2 | d |
select ID,wmsys.wm_concat(Val) as Path
from test
group by ID;
---------------------------------------------------------
id | path |
1 | a,c,e |
2 | b,d |