Oracle Sql Most uses Function

 

ROLLUP (Grand total)

select department_id , sum(salary) 

from hr.employees 

group by rollup(department_id)

//

select department_id ,E.JOB_ID, sum(salary) 

from hr.employees e

group by rollup(department_id,e.job_id)