Question

Как написать это команду

SELECT * FROM (SELECT JOB, SAL, DEPTNO FROM SCOTT.EMP)
PIVOT ( SUM(SAL) FOR DEPTNO IN (10, 20, 30))

с использованием rollup и cube?

Answer 1

SELECT JOB,

      SUM(CASE WHEN DEPTNO = 10 THEN SAL ELSE 0 END) AS "DEPTNO 10",

      SUM(CASE WHEN DEPTNO = 20 THEN SAL ELSE 0 END) AS "DEPTNO 20",

      SUM(CASE WHEN DEPTNO = 30 THEN SAL ELSE 0 END) AS "DEPTNO 30"

FROM SCOTT.EMP

GROUP BY ROLLUP (JOB);