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