Nikaの天地

Pivot 

 SELECT * FROM (SELECT A,B FROM TEMP_TABLE )
 PIVOT ( SUM(B )FOR A IN('B','D'));

 

-------------------------------------------------

Unpivot

 

SELECT  COLUMN_NAME,VALUE FROM TEMP_TABLE
UNPIVOT(VALUE FOR COLUMN_NAME IN(A,B,C,D,E,F,G,H));