User Tools

Site Tools


kurs:group_by_beispiele

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
kurs:group_by_beispiele [2012/09/25 17:22]
127.0.0.1 external edit
kurs:group_by_beispiele [2014/05/20 15:24]
mh
Line 1: Line 1:
 +<​code>​
 +with ym as (
 +select employee_id,​
 +    --   ​extract(year from hire_date) y,
 +       ​extract(month from hire_date) m
 +       from employees
 +
 +select m, count(employee_id)
 +  from ym 
 +       group by m
 +       order by m
 +</​code> ​      
 +       
 +
 +
 +<​code>​
 +with gehaltklassen as (
 +select salary, case when salary < 7000 then 0
 +            when salary < 12000 then 1
 +            else 2 end gehaltklasse
 +from employees
 +)
 +select gehaltklasse,​ dg, count(dg) from (
 +   ​select gehaltklasse,​ decode(gehaltklasse,​
 +          0, '​wenig',​
 +          1, '​mittel',​
 +          2, '​viel'​) dg
 +     from gehaltklassen )
 +group by gehaltklasse,​ dg 
 +order by gehaltklasse
 +</​code>​
  
 <​code>​ <​code>​
kurs/group_by_beispiele.txt ยท Last modified: 2020/05/18 11:25 by admin