除了Pivot和Unpivot这两个函数,还有像CASE WHEN + 聚合函数像MAX,SUM这类的来完成。今天发现Oracle下居然有这样一个和SQL SERVER 以后新增的新函数叫IIF相似功能的函数叫decode
SELECT *FROM (SELECT job,sum(decode(deptno,10,sal)) DEPT10,sum(decode(deptno,20,sal)) DEPT20,sum(decode(deptno,30,sal)) DEPT30,sum(decode(deptno,40,sal)) DEPT40FROM scott.empGROUP BY job)ORDER BY 1;JOB DEPT10DEPT20DEPT30DEPT40--------- ---------- ---------- ---------- ----------ANALYST6000CLERK 1300 1900 950MANAGER 2450 2975 2850PRESIDENT 5000SALESMAN5600