mssql) 년 _월_분기별 합계 쿼리

select * from sales
-- 년별 합계
select year(Orderdate), sum(subtotal) 
from sales
group by year(orderdate)
-- 월별 합계
select year(Orderdate),month(orderdate), sum(subtotal) 
from sales
group by year(orderdate),month(orderdate)
-- 년/월 함께 
select year(orderdate), month(orderdate), sum(subtotal) as sales
from sales 
where year(orderdate) = '2020'
group by grouping sets ((year(orderdate)), (year(orderdate),month(orderdate)))
-- 고객사별 월별 합계
select year(orderdate), month(orderdate),  isnull(customerid,0)  as '고객사',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))

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