行转列如何操作

Question

        id               name1 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.......

Answer 1

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