Differences

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

--- kurs:einfache_selects [2012/09/25 17:22]
127.0.0.1 external edit
+++ kurs:einfache_selects [2014/05/12 12:29]
mh
@@ Line 30: / Line 30: @@
 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>
+<code>
+with emp_com as (
+ select first_name,
+       last_name,
+       hire_date,
+       salary,
+       coalesce(commission_pct, 0) comm_pct
+     from employees
+)
+select first_name,
+       last_name,
+       hire_date,
+       salary,
+       comm_pct,
+       salary * comm_pct "der bonus"
+  from emp_com
+</code>
+<code>
+/* create view v_emp_com as
+ select first_name,
+       last_name,
+       hire_date,
+       salary+5 salary,
+       coalesce(commission_pct, 0) comm_pct
+     from employees
+*/
+select first_name,
+       last_name,
+       hire_date,
+       salary,
+       comm_pct,
+       salary * comm_pct "der bonus"
+  from v_emp_com
+</code>

dokuwiki