行变列，列变行

--行变列
select * from (select a,b,c from table) aa
pivot( SUM(c) FOR b IN ()) bb
order by a
--列变行
SELECT a,b,c from table
unpivot(c for b in())as aa
order by a