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
kurs:group_by_beispiele [2013/10/21 13:05]
mh
kurs:group_by_beispiele [2014/09/10 21:22] (current)
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>​ <​code>​
 with gehaltklassen as ( with gehaltklassen as (
kurs/group_by_beispiele.txt ยท Last modified: 2014/09/10 21:22 (external edit)