User Tools

Site Tools


kurs:einfache_selects

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
kurs:einfache_selects [2014/09/10 21:22]
127.0.0.1 external edit
kurs:einfache_selects [2020/05/05 12:06] (current)
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>​
 +
 +<​code>​
 +select first_name,
 +       ​last_name,​
 +       ​salary / 7,
 +       ​trunc(salary / 7, -3),
 +       ​round(salary / 7, 2)
 +from hr.employees
 +where salary > 12000
 +</​code>​
  
kurs/einfache_selects.1410376975.txt.gz ยท Last modified: 2014/09/10 21:22 by 127.0.0.1