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

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

瀏覽:350
日期:2025-04-30
--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...看更多