Oracle PL/SQL GROUP BY CUBE

ROLLUP will gradually remove a field on the right from the right to the left Based on the field following group by, and gradually sum up,

CUBE sums all the combinations of fields after group.

CUBE eg1:

1. SELECT department_id, job_id, SUM (salary)
2. FROM employees
3. WHERE department_id <60
4. Group by cube (job_id, department_id );
7. DEPARTMENT_ID JOB_ID SUM (SALARY)
8. ----------------------------------
9. 211200
10. 10 4400
11. 20 19000
12. 30 24900
13. 40 6500
14. 50 156400
15. HR_REP 6500
16. 40 HR_REP 6500
17. MK_MAN 13000
18. 20 MK_MAN 13000
19. MK_REP 6000
20. 20 MK_REP 6000
21. PU_MAN 11000
22. 30 PU_MAN 11000
23. ST_MAN 36400
24. 50 ST_MAN 36400
25. AD_ASST 4400
26. 10 AD_ASST 4400
27. PU_CLERK 13900
28. 30 PU_CLERK 13900
29. SH_CLERK 64300
31. DEPARTMENT_ID JOB_ID SUM (SALARY)
32. ----------------------------------
33. 50 SH_CLERK 64300
34. ST_CLERK 55700
35. 50 ST_CLERK 55700
37. 24 rows selected.

CUBE eg2:

1. SELECT department_id, job_id, SUM (salary)
2. FROM employees
3. WHERE department_id <60
4. Group by cube (department_id, job_id );
7. DEPARTMENT_ID JOB_ID SUM (SALARY)
8. ----------------------------------
9. 211200
10. HR_REP 6500
11. MK_MAN 13000
12. MK_REP 6000
13. PU_MAN 11000
14. ST_MAN 36400
15. AD_ASST 4400
16. PU_CLERK 13900
17. SH_CLERK 64300
18. ST_CLERK 55700
19. 10 4400
20. 10 AD_ASST 4400
21. 20 19000
22. 20 MK_MAN 13000
23. 20 MK_REP 6000
24. 30 24900
25. 30 PU_MAN 11000
26. 30 PU_CLERK 13900
27. 40 6500
28. 40 HR_REP 6500
29. 50 156400
31. DEPARTMENT_ID JOB_ID SUM (SALARY)
32. ----------------------------------
33. 50 ST_MAN 36400
34. 50 SH_CLERK 64300
35. 50 ST_CLERK 55700
37. 24 rows selected.