kurs:rollup_und_cube
Differences
This shows you the differences between two versions of the page.
|
kurs:rollup_und_cube [2010/05/18 11:15] 127.0.0.1 external edit |
kurs:rollup_und_cube [2014/09/10 21:22] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | <code> | + | |
| - | 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 | + | |
| - | </code> | + | |
kurs/rollup_und_cube.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
