ROLLUP 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 rollup(COMPANY_ID,DEP_DESIG) ORDER BY COMPANY_ID;