rollup and cube operations

query.sql

--ROLLUP AND CUBE OPERATIONS

select department_id , sum(salary)
from employees group by department_id
order by department_id;

select department_id ,job_id, sum(salary)
from employees group by department_id,job_id
order by department_id;

select department_id ,job_id, sum(salary)
from employees group by rollup(department_id,job_id)
order by department_id;


--cube First groups sub-group ie: sum of above two query
select department_id ,job_id, sum(salary)
from employees group by cube(department_id,job_id);