3,494
社区成员




with tb as(
select '2005-01-01' C1,1 c2 from dual union all
select '2005-01-01', 3 from dual union all
select '2005-01-01', 4 from dual union all
select '2005-01-02', 5 from dual union all
select '2005-01-02', 6 from dual)
--以上为提供数据的语句
select c1,replace(wm_concat(c2),',','-') col2
from tb
group by c1
C1 COL2
---------- --------------------
2005-01-01 1-3-4
2005-01-02 5-6