|
1、
SELECT wmsys.wm_concat(t.org) orgs,t.area_name
FROM (SELECT concat(concat(b.abbreviation,‘-‘),b.org_name) org,
a.area_name area_name
FROM t_organization? b
left join t_area_store a
on a.store_code = b.unit_id
WHERE b.close_date is null
and b.abbreviation is not null
ORDER BY a.area_name) t
group by t.area_name
该语句获取的结果为：orgs 字段类型为clob类型，若果前段需要展示时得再次处理
?
2、
SELECT LISTAGG(to_char(t.org),‘,‘) within group(ORDER BY t.area_name) as orgs,
t.area_nameFROM (SELECT concat(concat(b.abbreviation,
a.area_name area_name
FROM t_organization b
left join t_area_store a
on a.store_code = b.unit_id
WHERE b.close_date is null
and b.abbreviation is not null
ORDER BY a.area_name) t
group by t.area_name
结果为：orgs字段为字符串类型，前端页面展示无需再次处理
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
