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
kurs:einfache_selects [2020/05/05 10:03]
admin
kurs:einfache_selects [2020/05/05 12:06] (current)
admin
Line 94: Line 94:
 from hr.employees where  from hr.employees where 
 employee_id in (144, 145) 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>​ </​code>​
  
kurs/einfache_selects.txt ยท Last modified: 2020/05/05 12:06 by admin