求一个SQL语句

数据库中有字段ID,SILVER
存储的数据如下
1 0
2 0
3 0
4 1
5 99
6 2


可以直接写脚本返回0,0,0,1,99,2吗？就是返回字符串用逗号隔开

---

SQL code:

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

---

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

select wmsys.wm_concat(SILVER) from tb;

---

select wm_concat(列) from 表

---

好方法，学习！