select a.*,rownum ros from (
select listagg(t1.zt_hz,',') within group (order by t.NSRSBH) pj
from dt_gkjl_gkjlls t, nsr_dm_pj t1
WHERE t.pjnsrid = t1.zt_dm
and t.NSRSBH='370784199110286434'
order by t.qhsj desc)a
oracle数据库中将列字段拼接成字符串
最新推荐文章于 2023-07-21 11:32:55 发布