CUBE IN ORACLE.

DROP TABLE EMPLOYEE;

CREATE TABLE EMPLOYEE(
COMPANY_ID NUMBER,
DEP_DESIG VARCHAR(20),
SALARY NUMBER
);


INSERT INTO EMPLOYEE VALUES(10,'Developer',80);
INSERT INTO EMPLOYEE VALUES(10,'Manager',100);
INSERT INTO EMPLOYEE VALUES(10,'CEO',150);
INSERT INTO EMPLOYEE VALUES(20,'Developer',100);
INSERT INTO EMPLOYEE VALUES(20,'Manager',500);
INSERT INTO EMPLOYEE VALUES(20,'CEO',600);


SELECT COMPANY_ID, DEP_DESIG, COUNT(*), SUM(SALARY)
FROM EMPLOYEE
GROUP BY CUBE(COMPANY_ID,DEP_DESIG) ORDER BY COMPANY_ID;

OUTPUT:
-------

COMPANY_ID DEP_DESIG COUNT(*) SUM(SALARY)
---------------------- -------------------- ---------------------- ----------------------
10 CEO 1 150
10 Developer 1 80
10 Manager 1 100
10 3 330
20 CEO 1 600
20 Developer 1 100
20 Manager 1 500
20 3 1200
CEO 2 750
Developer 2 180
Manager 2 600
6 1530

12 rows selected