kurs:grouping_sets
Differences
This shows you the differences between two versions of the page.
| — |
kurs:grouping_sets [2014/09/10 21:22] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | <code> | ||
| + | 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) ) | ||
| + | </code> | ||
kurs/grouping_sets.txt · Last modified: 2014/09/10 21:22 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
