Oracle - ROLLUP예제1

[ Oracle - ROLLUP예제1 ]

 

WITH t AS  (  SELECT 'A1' g1, 'B1' g2, 'MM' unit, 10 qty FROM dual  UNION ALL SELECT 'A1' G1, 'B2' G2, 'EA' UNIT, 20 QTY FROM dual  UNION ALL SELECT 'A2' G1, 'B2' G2, 'EA' UNIT, 15 QTY FROM dual  )  SELECT g1, g2, unit  , SUM(qty) qty  FROM t  GROUP BY ROLLUP(g1, (g2, unit))  ;