Pivotal sql
SELECT *
FROM (SELECT job,
sum(decode(deptno,10,sal))
sum(decode(deptno,20,sal))
sum(decode(deptno,30,sal))
sum(decode(deptno,40,sal))
FROM scott.emp
GROUP BY job)
ORDER BY 1;
Is there a way to make deptno a select from scott.dept table? not hardcode it. Thanks
FROM (SELECT job,
sum(decode(deptno,10,sal))
sum(decode(deptno,20,sal))
sum(decode(deptno,30,sal))
sum(decode(deptno,40,sal))
FROM scott.emp
GROUP BY job)
ORDER BY 1;
Is there a way to make deptno a select from scott.dept table? not hardcode it. Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER