--1. 哪些部门的人数比90 号部门的人数多。
select department_id ,count(*)
from employees
group by department_id
having count(*)>(select count(*) from employees where department_id=90);
--2. Den(FIRST_NAME)、Raphaely(LAST_NAME)的领导是谁(非关联子查询)。
select first_name||' '||last_name from employees where employee_id = (
select manager_id from employees where first_name='Den' and last_name='Raphaely');
--3. Den(FIRST_NAME)、Raphaely(LAST_NAME) 领导谁(非关联子查询)。
select first_name||' '||last_name from employees where manager_id = (
select employee_id from employees where first_name='Den' and last_name='Raphaely');
--4. Den(FIRST_NAME)、Raphaely(LAST_NAME) 的领导是谁(关联子查询)。
select first_name||' '||last_name
from employees a
where exists
(select 1 from employees b
where a.employee_id=b.manager_id
and b.first_name='Den'
and b.last_name='Raphaely');
Oracle经典查询练手第一篇
最新推荐文章于 2020-12-18 20:01:36 发布