데이터베이스 질문과 답변
별표시로 모든거 가져 오는 방법말고
컬럼을 지정해서 가쟈 올수 있나요?
프로그램에서 필요해서요...
select *
from (
select job
,deptno
,sal
from emp
)
pivot (
sum(sal) as a1
,sum(sal) as b1
for job in ('CLERK','MANAGER','PRESIDENT','ANALYST','SALESMAN')
)
컬럼을 지정해서 가쟈 올수 있나요?
프로그램에서 필요해서요...
select *
from (
select job
,deptno
,sal
from emp
)
pivot (
sum(sal) as a1
,sum(sal) as b1
for job in ('CLERK','MANAGER','PRESIDENT','ANALYST','SALESMAN')
)
by 마농
[2011.08.25 11:35:09]
SELECT deptno
, clerk_a1
, manager_a1
, clerk_b1
, manager_b1
FROM (SELECT job, deptno, sal FROM emp)
PIVOT
( SUM(sal) AS a1
, SUM(sal) AS b1
FOR JOB IN
( 'CLERK' AS clerk
, 'MANAGER' AS manager
, 'PRESIDENT' AS president
, 'ANALYST' AS analyst
, 'SALESMAN' AS salesman
)
)
;
, clerk_a1
, manager_a1
, clerk_b1
, manager_b1
FROM (SELECT job, deptno, sal FROM emp)
PIVOT
( SUM(sal) AS a1
, SUM(sal) AS b1
FOR JOB IN
( 'CLERK' AS clerk
, 'MANAGER' AS manager
, 'PRESIDENT' AS president
, 'ANALYST' AS analyst
, 'SALESMAN' AS salesman
)
)
;
by 문자
[2011.08.25 14:57:11]
ㄳ 합니다.
) 버튼을 클릭하여 작성 하시면 됩니다.