question

When you say that you don't want to show the null values I'm assuming that you don't want to show the row at all if and of the sum values is a null. If that's the case you should just add a where clause to eliminate those rows: SELECT JOB, SUM(DECODE(DEPTNO,10,SAL)) DEPT10, SUM(DECODE(DEPTNO,20,SAL)) DEPT20, SUM(DECODE(DEPTNO,30,SAL)) DEPT30, SUM(SAL) TOTAL FROM EMP WHERE SUM(DECODE(DEPTNO,10,SAL)) IS NOT NULL AND SUM(DECODE(DEPTNO,20,SAL)) IS NOT NULL AND SUM(DECODE(DEPTNO,30,SAL)) IS NOT NULL GROUP BY JOB; Alternatively if you meant you wanted to show something other than a null value for those records that are currently null: SELECT JOB, ISNULL(SUM(DECODE(DEPTNO,10,SAL)),0) DEPT10, ISNULL(SUM(DECODE(DEPTNO,20,SAL)),0) DEPT20, ISNULL(SUM(DECODE(DEPTNO,30,SAL)),0) DEPT30, ISNULL(SUM(SAL),0) TOTAL FROM EMP GROUP BY JOB;