User Tools

Site Tools


kurs:einfache_subquery
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')
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)