User Tools

Site Tools


kurs:case

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
kurs:case [2015/10/19 10:58]
mh
kurs:case [2020/05/11 09:26] (current)
admin
Line 32: Line 32:
       '​error'​) ​       '​error'​) ​
 </​code> ​     </​code> ​    
 +
 +
 +<​code>​
 +select first_name,
 +    last_name,
 +    salary,
 +    decode(gehalts_kategorie,​
 +    0, '​wenig',​
 +    1, '​mittel',​
 +    2, '​viel',​
 +    '​FEHLER!!!'​) gehalts_kategorie_name
 +from (
 +select first_name,
 +       ​last_name,​
 +       ​salary, ​      
 +(case when salary < 5000 then 0
 +      when salary < 10000 then 1
 +      else 2 
 +end) gehalts_kategorie
 +from hr.employees
 +
 +order by gehalts_kategorie,​ salary, last_name, first_name;
 +</​code>​
  
 decode decode
kurs/case.txt ยท Last modified: 2020/05/11 09:26 by admin