User Tools

Site Tools


kurs:oracle-sql

Differences

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

Link to this comparison view

kurs:oracle-sql [2011/12/16 13:27]
mh
kurs:oracle-sql [2014/09/10 21:22]
Line 1: Line 1:
-[[einfache selects]] 
  
-<​code>​ 
-select first_name, ​ 
-       ​last_name, ​ 
-       ​salary from employees 
-where salary >= 10000 and 
-      salary <  15000 
-order by salary desc 
-select first_name, ​ 
-       ​last_name, ​ 
-       ​salary from employees 
-where salary in('​10000',​ 
-'​11000',​ 
-'​13000'​ 
-) 
-order by salary desc 
- 
- 
-select first_name, ​ 
-       ​last_name, ​ 
-       ​salary from employees 
-where salary not between 10000 and 14000 
-and salary not in (10000, 14000) 
-order by salary desc 
-</​code>​ 
kurs/oracle-sql.txt ยท Last modified: 2014/09/10 21:22 (external edit)