This shows you the differences between two versions of the page.
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> | + |