SQL语句把行转换为列，表1转为表2

请问怎么将表1转换为表2哇，用SQL语句

(select "一季度" as 季度, 一季度 as 值 from table) union
(select "二季度" as 季度, 二季度 as 值 from table) union
(select "三季度" as 季度, 三季度 as 值 from table) union
(select "四季度" as 季度, 四季度 as 值 from table)

https://blog.csdn.net/shafo1/article/details/7062882

PIVOT 了解一下.........