with test as
(
select 'Y' as sa,'A' as scode,'1%' as srate from dual
union all
select 'Y','B','1%' from dual
)
select sa,listagg(scode,',') within group(order by scode) as scode,srate from test group by sa,srate;--oracle11g才支持
--或者
select sa,wmsys.wm_concat(scode) as scode,srate from test group by sa,srate;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货