行转列如何操作
id name

1 9574676 Zhirong
2 9574676 Rongguan
3 9751861 Runrong
4 9751861 Shangdun
5 9751861 Shangdun
6 9751861 Huiyin
7 9751861 Huiyin
8 10000630 Rongguan
9 10000630 Nanguo
10 10000630 Nanguo
11 10000630 Rongguan
12 10022819 Huiyin
13 10022819 Rongguan
14 10022819 Rongguan
15 10022819 Shangdun
16 10795537 Runrong
17 10795537 Runrong
18 10795537 Runrong
19 10795537 Jicheng
20 10795537 Jicheng
21 10824003 Jicheng
22 10824003 Jicheng
23 10824003 Jicheng
24 11904701 Runrong
25 12286456 Rongguan
26 12305025 Jicheng
27 12305025 Jicheng
28 12689608 Jicheng
29 12945753 Runrong
30 12945753 Runrong
31 13279518 Rongguan

.......

------解决方案--------------------
因为行列数随机，不好做转换，用
select no,wm_concat(name) from table group by no;
生成的诸如
9574676 Zhirong,Rongguan,Runrong,Shangdun...
的形式能否满足需要？
------解决方案--------------------
wm_concat