glufke.net - Dicas, truques e boas-práticas sobre a tecnologia Oracle, Forms, Reports, SQL, Tunning e muito mais!!
https://glufke.net/oracle/
AAA 50
BB 30
total 80
SELECT
DECODE(GROUPING(DEPTNO),1,'TOTAL----->',DEPTNO) DEPTNO,
COUNT(*) QTD
FROM EMP
GROUP BY ROLLUP(DEPTNO)
/
DEPTNO QTD
--------------------------------- ----------
20 4
30 6
50 1
TOTAL-----> 11