Oracle10 多行和并

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

Oracle10 多行和并

标签：