Query for job wise and dept wise total salary

select job,sum(sal) Totsal,sum(decode(deptno,10,sal)) "Deptno10"
                   ,sum(decode(deptno,20,sal)) "Deptno20"
                   ,sum(decode(deptno,30,sal)) "Deptno30"
                    from emp group by job;