LITTLE BY LITTLE

그룹 함수 (WITH ROLLUP, WITH CUBE, GROUPING SETS, GROUPING) WITH ROLLUP : GROUP BY 항목들을 오른쪽에서 왼쪽 순서대로 그룹을 묶는 역할 WITH ROLLUP 사용 안할경우 SELECT YEAR(order_date) AS 연도 ,channel_code AS 채널코드 ,SUM(sales_amt) AS 주문금액 FROM [Order] GROUP BYYEAR(order_date) ,channel_code 마지막 ORDER BY 직전에 WITH ROLL UP추가 SELECT YEAR(order_date) AS 연도 ,channel_code AS 채널코드 ,SUM(sales_amt) AS 주문금액 FROM [Order] GROUP BY YEAR(order_d..