PIVOT ํ ๋ฐ์ดํฐ๋ฅผ ์ด ๋ฐ์ดํฐ๋ก ๋ณํ์์ (EMPLOYEE ํ ์ด๋ธ)DEPTJOBSALARYSalesManager5000SalesClerk1500ITManager4000ITClerk2000 ์์ ๋ฐ์ดํฐ๋ฅผ PIVOT์ ์ฌ์ฉํ์ฌ ๊ฐ ๋ถ์๋ณ๋ก JOB์ ์ด๋ก ๋ณํํ๊ณ SALARY๋ฅผ ํ์ํด๋ณด์. SELECT *FROM ( SELECT DEPT, JOB, SALARY FROM employee) PIVOT ( SUM(SALARY) FOR JOB IN ('Manager' AS MANAGER, 'Clerk' AS CLERK)); ๊ฒฐ๊ณผDEPTMANAGERCLERKSales50001500IT40002000 UNPIVOT ์ด ๋ฐ์ดํฐ๋ฅผ ํ ๋ฐ์ดํฐ๋ก ๋ณํ์์ (DEPARTMENT_SALARY)DEPT..
