Thursday, 13 March 2014

How to make Matrix Report in Oracle SQL (PIVIOT)

Purpose: Matrix Report in Oracle SQL using PIVIOT

SELECT * FROM scott.emp
PIVOT
(
SUM(sal)
FOR deptno
IN (10 AS "Ten", 20 AS "Twenty", 30)
)

No comments:

Post a Comment