Differences

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

--- kurs:case [2014/09/10 21:22]
127.0.0.1 external edit
+++ kurs:case [2020/05/11 09:26] (current)
admin
@@ Line 6: / Line 6: @@
   end) altersgruppe
  from employees order by hire_date desc;
+</code>
+<code>
+select first_name,
+       last_name,
+       hire_date,
+       age_class from
+(select first_name,
+       last_name,
+       hire_date,
+       case when hd < 2003 then 'old'
+            when hd < 2005 then 'average'
+            when hd < 2007 then 'young'
+            else 'even younger' end age_class
+  from
+  (select first_name,
+       last_name,
+       hire_date,
+       extract(year from hire_date) hd from employees))
+ order by decode(age_class,
+      'old', 0,
+      'average', 1,
+      'young', 2,
+      'even younger', 3,
+      'error')
+</code>
+<code>
+select first_name,
+    last_name,
+    salary,
+    decode(gehalts_kategorie,
+, 'wenig',
+, 'mittel',
+, '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

dokuwiki