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...