select * from (select deptno,job,sal from emp) pivot(sum(sal)for job in ('PRESIDENT','MANAGER','ANALYST','CLERK','SALESMAN'))order by deptno;
谁能仔细的说这段代码的意思
select * from (select deptno,job,sal from emp) pivot(sum(sal)for job in ('PRESIDENT','MANAGER','ANALYST','CLERK','SALESMAN'))order by deptno;
谁能仔细的说这段代码的意思