sql 查询求助(不一样的列转行)

[啰哩]

请教高手，以下表格如何转换？

[啰哩]

有人指教一下吗？寻求帮助

[AHUA1001]

select id , name, jidu, xiaoshou from ( SELECT 1 id,'苹果' name,1000 Q1,2000 Q2,3300 Q3,5000 Q4 FROM 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) ) ;

[wildwolv]

select date,'rock1' as rock,rock1 temp as temp,rock1 press as press from table union ALL select date,'rock2' as rock,rock2 temp as temp,rock2 press as press from table union ALL ......

[啰哩]

多谢指点，解决了我的一个问题