dokuwiki

This is an old revision of the document!

---

select last_name, to_char(hire_date, 'yyyy') as hy,
 (case when to_char(hire_date, 'yyyy')>1995 then 'jung'
       when to_char(hire_date, 'yyyy')>1992 then 'mittel'
       else 'alt'
  end) altersgruppe
 from employees order by hire_date desc;

decode