求一个SQL语句

Question

数据库中有字段ID,SILVER
存储的数据如下
1 0
2 0
3 0
4 1
5 99
6 2
可以直接写脚本返回0,0,0,1,99,2吗？就是返回字符串用逗号隔开

Answer 1

SELECT ID,
       REPLACE(MAX(LTRIM(SYS_CONNECT_BY_PATH(DECODE(RN,
                                                    1,
                                                    TO_CHAR(SILVER),
                                                    ' '),
                                             ','),
                         ',')),
               ' ,',
               '') A
  FROM (SELECT TT.*, ROW_NUMBER() OVER(PARTITION BY ID ORDER BY ROWNUM) RN
          FROM TABLE1 TT)
 START WITH RN = 1
CONNECT BY PRIOR RN = RN - 1
 GROUP BY ID

Answer 2

select wm_concat(silver) from tb

Answer 3

10g版本的用wmsys.wm_concat()函数即可。9i不支持select wmsys.wm_concat(SILVER) from tb;

Answer 4

select wm_concat(列) from 表