在上次的列转行的基础之上:
SELECT *
FROM
(SELECT deptno, empjob, sal FROM emp
) pivot( SUM(sal) FOR empjob IN ( 'PRESIDENT' AS PRESIDENT, 'MANAGER' AS MANAGER, 'ANALYST' AS ANALYST, 'CLERK' AS CLERK, 'SALESMAN' AS SALESMAN ) )
ORDER BY deptn
在上次的列转行的基础之上:
SELECT *
FROM
(SELECT deptno, empjob, sal FROM emp
) pivot( SUM(sal) FOR empjob IN ( 'PRESIDENT' AS PRESIDENT, 'MANAGER' AS MANAGER, 'ANALYST' AS ANALYST, 'CLERK' AS CLERK, 'SALESMAN' AS SALESMAN ) )
ORDER BY deptn