User Tools

Site Tools


kurs:grouping_sets
select job_id, department_name, e.manager_id, count(e.employee_id)
  from employees e, departments d
where e.department_id = d.department_id
  group by 
  grouping sets
 -- (department_name, job_id, e.manager_id),
( (department_name, job_id),
  (job_id, e.manager_id) )
kurs/grouping_sets.txt · Last modified: 2014/09/10 21:22 (external edit)