-- 查询工资高于Jack的员工id和姓名-- 1. 找出Jack的工资-- 2. 得到Jack工资,作为条件查询对应的员工信息select salary
from t_employees
where first_name ='Jack';select employee_id, first_name
from t_employees
where salary >8400;-- 整合为子查询-- 条件判断select employee_id, first_name
from t_employees
where salary >(select salary
from t_employees
where first_name ='Jack');
1.3 子查询结果作为枚举限制 in
-- 查询和Jack同部门的员工信息-- 1. 找出Jack的部门编号select department_id
from t_employees
where first_name ='Jack';-- 2. 根据Jack的部门编号,使用in枚举查询,限制条件select employee_id, first_name
from t_employees
where department_id in(80);-- 整合为子查询select employee_id, first_name
from t_employees
where department_id in(select department_id
from t_employees
where first_name ='Jack');