SELECT fspc, wmsys.wm_concat (jsrzmc) as jsr FROM dxjsrxx GROUP BY fspc
select fspc, LISTAGG(jsrzmc,',') WITHIN GROUP( ORDER BY fspc) jsr
from dxjsrxx group by fspc
SELECT fspc, wmsys.wm_concat (jsrzmc) as jsr FROM dxjsrxx GROUP BY fspc
select fspc, LISTAGG(jsrzmc,',') WITHIN GROUP( ORDER BY fspc) jsr
from dxjsrxx group by fspc