emp 테이블에서부서(deptno)별로소계를내려면아래와같이쿼리를해준다.

SELECT   deptno

       , ename

       , SUM (sal) sal

    FROM emp

GROUP BY deptno

       , ROLLUP (ename)

    DEPTNO ENAME             SAL

---------- ---------- ----------

        10 KING             5000

        10 CLARK            2450

        10 MILLER           1300

        10                  8750

        20 FORD             3000

        20 ADAMS            1100

        20 JONES            2975

        20 SCOTT            3000

        20 SMITH             800

        20                 10875

        30 WARD             1250

        30 ALLEN            1600

        30 BLAKE            2850

        30 JAMES             950

        30 MARTIN           1250

        30 TURNER           1500

        30                  9400

하잖아요...

엠에스에스큐엘에서는 큐브 문장을 쓰는 것 같던데요...

포스트그래에서는 어떻게 하는지 궁금합니다...