update语句中使用子查询

56. 删除 108 号员工所在部门中工资最低的那个员工.1. 查询 108 员工所在的部门 id

select department idfrom employees where employee id = 108;

2. 查询 1 部门中的最低工资

select minsalaryfrom employeeswhere department id = select department idfrom employees where employee id = 108;

3. 删除 1 部门中工资为 2 的员工信息

delete from employees where salary = select minsalaryfrom employeeswhere department id = select department idfrom employees where employee id = 108 and department id = select department idfrom employees where employee id = 108