User Tools

Site Tools


kurs:oracle-sql

Differences

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

Link to this comparison view

Next revision
Previous revision
kurs:oracle-sql [2011/12/16 10:57]
mh created
kurs:oracle-sql [2011/12/16 13:29]
mh
Line 1: Line 1:
-<​code>​ +[[einfache selects]]
-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+
  
- +[[distinct nur auf einzelne Spalten]]
-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)