dokuwiki

This is an old revision of the document!

---

SELECT  nvl(departments.department_name, 'Summe Department') as dep, 
        grouping(department_name) as gd,
        nvl(job_id, 'Summe Jobs') as job, grouping(job_id) as gj,
        count(last_name), sum(employees.salary)       
  FROM departments, employees
 WHERE ((departments.department_id = employees.department_id))
 group by rollup (department_name, job_id)
 order by department_name, job_id