sql查询语句高手进
a b
200604862 10
200604862 20
200604862 30
------------------------
查询后结果如下：
200604862 10,20,30
请问该如何写呢？
[解决办法]
Select x,max(substr((sys_connect_by_path(y, ', ')),2)) cola
from ( select x,y, rownum rnum,
row_number() over(partition by x order by x) rn1
from a )
start with rn1=1
connect by rnum-1=prior rnum
group by x
