Fahd Bahoo Blog for Oracle Database
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment