oracle查询，多个字段合拼为一个字段（有图）
问题描述：
答
试试这个
select id, ltrim(sys_connect_by_path(name, ','), ',') name
from (select id,
name,
row_number() over(partition by id order by name) rn,
count(*) over(partition by id) cnt
from table) t
where rn = cnt
start with rn = 1
connect by prior id = id
and prior rn = rn - 1
order by id;
答
把table换成你的表名，id和name为你表里的字段
答
用函数wmsys.wm_concat
select id， wmsys.wm_concat(name) as names
from table
group by id
order by id
答
用函数wmsys.wm_concat
select id， wmsys.wm_concat(name) as names
from table
group by id
order by id