ORACLE行轉列(行轉一列，行轉多列) _ 資料庫_ - 010cnc.net

--listagg(合併多行的值為字元串，只用一列來顯示) select status, count(*), listagg(risk_id, ',') within group (order by risk_id) from rp_risk group by status; select risk_id, status, listagg(risk_id, ',') within group (order by risk_id) over(partition by status) from rp_risk

www.010cnc.net