Differences

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

--- kurs:einfache_subquery [2010/10/28 15:24]
mh created
+++ kurs:einfache_subquery [2014/09/10 21:22] (current)
@@ Line 1: / Line 1: @@
+<code>
+select avg(salary) from employees
+select first_name, last_name from employees where
+salary > 6461
+select first_name, last_name from employees where
+salary > (select avg(salary) from employees)
+select first_name, last_name from employees where
+salary > (select salary from employees
+               where first_name = 'Pat' and
+                     last_name  = 'Fay')
+select first_name, last_name, salary from employees where
+salary > any (select salary from employees
+               where last_name  = 'King')
+select last_name, count(last_name) from employees
+group by last_name
+having count(last_name) > 1
+select employee_id from employees where last_name = 'King'
+select salary from employees where employee_id in (156, 100)
+select salary from employees where employee_id = 156 or
+                                   employee_id =  100
+select salary from employees where employee_id
+    in (select employee_id from employees where last_name = 'King')
+</code>
 <code>
 select avg(salary) from employees e, departments d
@@ Line 12: / Line 50: @@
                department_name = 'IT')
 </code>
+<code>

dokuwiki