請教高手，以下表格如何轉換？
uj5u.com熱心網友回復：
有人指教一下嗎？尋求幫助uj5u.com熱心網友回復：
select id , name, jidu, xiaoshou from ( SELECT 1 id,'蘋果' name,1000 Q1,2000 Q2,3300 Q3,5000 Q4FROM DUAL UNION ALL
SELECT 2 id,'橘子' name,3000 Q1,3000 Q2,3200 Q3,1500 Q4
FROM DUAL UNION ALL
SELECT 3 id,'香蕉' name,2500 Q1,3500 Q2,2200 Q3,2500 Q4
FROM DUAL UNION ALL
SELECT 4 id,'葡萄' name,1500 Q1,2500 Q2,1200 Q3,3500 Q4
FROM DUAL) unpivot (xiaoshou for jidu in (q1, q2, q3, q4) ) ;
uj5u.com熱心網友回復：
select date,'rock1' as rock,rock1 temp as temp,rock1 press as press from tableunion ALL
select date,'rock2' as rock,rock2 temp as temp,rock2 press as press from table
union ALL
......
uj5u.com熱心網友回復：
多謝指點，解決了我的一個問題轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/32952.html
標籤：基礎和管理