MySQL数据库表: employees库表测试试数据
#--
#--单行子查询练习
#--1.显示工资比’Allan’(first_name)高的所有员工的姓名和工资
#--第一步 查询Allan的工资
SELECT e.salary FROM employees e WHERE e.first_name LIKE 'Allan' #--tb1
#--第二步 where子查询
select salary from employees where salary > (tb1)
#--第三步 查询比Allan的工资9000高的所有员工
SELECT e2.first_name, e2.salary FROM employees e2
WHERE e2.salary>(SELECT e.salary FROM employees e WHERE e.first_name LIKE 'Allan' )
#--子查询
#--2.查询最低工资大于50号部门最低工资的部门id和其最低工资
#--第一步 查询50号部门的最低工资
(select min(salary) from employees where department_id = 50) #--tb1
#--第二步 按部门分组,查询各部门最低工资> tb1
select department_id,min(salary) from employees group by department_id
#--第三步 查询各部门最低工资> tb1
select department_id,min(salary) from employees
group by department_id
having min(salary) > (se