行转列如何操作
id name
19574676 Zhirong
29574676 Rongguan
39751861 Runrong
49751861 Shangdun
59751861 Shangdun
69751861 Huiyin
79751861 Huiyin
810000630Rongguan
910000630Nanguo
1010000630Nanguo
1110000630Rongguan
1210022819Huiyin
1310022819Rongguan
1410022819Rongguan
1510022819Shangdun
1610795537Runrong
1710795537Runrong
1810795537Runrong
1910795537Jicheng
2010795537Jicheng
2110824003Jicheng
2210824003Jicheng
2310824003Jicheng
2411904701Runrong
2512286456Rongguan
2612305025Jicheng
2712305025Jicheng
2812689608Jicheng
2912945753Runrong
3012945753Runrong
3113279518Rongguan
.......
[解决办法]
因为行列数随机，不好做转换，用
select no,wm_concat(name) from table group by no;
生成的诸如
9574676 Zhirong,Rongguan,Runrong,Shangdun...
的形式能否满足需要？
[解决办法]
wm_concat
