Differences

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

--- kurs:einfache_subquery [2012/09/25 17:22]
127.0.0.1 external edit
+++ kurs:einfache_subquery [2014/09/10 21:22]
@@ 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
-where d.department_id = e.department_id and
-      department_name = 'IT'
-select first_name, last_name, salary from employees
-where salary > 5760
-select first_name, last_name, salary from employees e
-where salary > (select avg(salary) from employees e, departments d
-               where d.department_id = e.department_id and
-               department_name = 'IT')
-</code>

dokuwiki

User Tools

Site Tools

Differences

Page Tools