mssql) Pivot

-- convert tows into columns
select [1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12],customer
from
(select year(orderdate) as [year], month(orderdate) as [month],  isnull(customerid,0) as customer  ,sum(subtotal)as sales
from sales 
where year(orderdate) = '2020'
group by grouping sets ((year(orderdate)), (year(orderdate),month(orderdate)), (year(orderdate),month(orderdate),customerid))

) as Source_table
pivot 
(Max(sales) for [month] in([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12])

)as Pivot_table
order by customer desc

#pivot쿼리 #개발자 #개발자공부 #웹프로그래머 #쿼리 #mssql