Differences

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

--- kurs:oracle-sql [2011/12/16 10:57]
mh created
+++ kurs:oracle-sql [2014/09/10 21:22] (current)
@@ 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>

dokuwiki