Group, add and total.

[tfg]

I want to add a value per group but I also want to receive the total of everything in the same query. It's possible ?

Something like this:

Select all

AAA    50 
BB     30 
total  80 

[dr_gori]

Group, account and still gives the total

is in the user scott ...

Select all

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