kurs:einfache_subquery
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] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | <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> | ||
kurs/einfache_subquery.txt ยท Last modified: 2014/09/10 21:22 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
