This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Last revision Both sides next revision | ||
kurs:einfache_selects [2014/09/10 21:22] 127.0.0.1 external edit |
kurs:einfache_selects [2020/05/05 10:03] admin |
||
---|---|---|---|
Line 83: | Line 83: | ||
from v_emp_com | from v_emp_com | ||
</code> | </code> | ||
+ | |||
+ | |||
+ | <code> | ||
+ | select | ||
+ | employee_id, | ||
+ | first_name, | ||
+ | last_name, | ||
+ | coalesce(to_char(commission_pct), 'n/a'), | ||
+ | salary * coalesce(commission_pct, 0) as bonus | ||
+ | from hr.employees where | ||
+ | employee_id in (144, 145) | ||
+ | </code> | ||