有如下数据:
name applydate
张xx 2011-7-18
王xx 2011-7-18
李xx 2011-7-18张xx 2011-7-15
王xx 2011-7-15
李xx 2011-7-15
赵xx 2011-7-15希望出来的效果是:
name applydate
张xx,王xx ,李xx 2011-7-18
name applydate
张xx,王xx ,李xx,赵xx 2011-7-15求可执行SQL
name applydate
张xx 2011-7-18
王xx 2011-7-18
李xx 2011-7-18张xx 2011-7-15
王xx 2011-7-15
李xx 2011-7-15
赵xx 2011-7-15希望出来的效果是:
name applydate
张xx,王xx ,李xx 2011-7-18
name applydate
张xx,王xx ,李xx,赵xx 2011-7-15求可执行SQL
with tab as(
select '张xx' name,'2011-7-18' applydate from dual
union all
select '王xx' name,'2011-7-18' applydate from dual
union all
select '李xx' name,'2011-7-18' applydate from dual
union all
select '张xx' name,'2011-7-15' applydate from dual
union all
select '王xx' name,'2011-7-15' applydate from dual
union all
select '李xx' name,'2011-7-15' applydate from dual
union all
select '赵xx' name,'2011-7-15' applydate from dual
)
select wm_concat(tab.name),tab.applydate
from tab
group by tab.applydate
from tab
group by tab.applydate发现这句话就搞定了 多谢多谢 哈哈