Differences

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

--- kurs:einfache_selects [2011/12/16 13:28]
mh
+++ kurs:einfache_selects [2013/04/29 12:46]
mh
@@ Line 1: / Line 1: @@
 <code>
-select last_name, department_id from employees where department_id = 50 or department_id = 60
+select last_name, department_id
+  from employees
+  where
+  department_id = 50 or department_id = 60
 </code>
@@ Line 26: / Line 29: @@
 and salary not in (10000, 14000)
 order by salary desc
+</code>
+null felder
+<code>
+select first_name vorname,
+       last_name,
+       salary,
+  --     salary * 2,
+       salary + salary * coalesce(commission_pct, 0) auszahlung,
+       coalesce(commission_pct, 0) cp
+  from employees
+  where salary + salary * coalesce(commission_pct, 0) > 10000
+  order by cp asc
+       -- commission_pct is null
+       -- commission_pct in (0.15, 0.2, 0.3, null)
 </code>

dokuwiki