例题:# 各个部门中 最高工资中最低的那个部门的 最低工资是多少?
先考虑取得各个部门最高工资
SELECT MAX(salary) AS max_salary,e.`department_id` did FROM employees e GROUP BY e.`department_id`
结果为:
再将此表命名tmp在进行查询
SELECT MIN(max_salary),did FROM (<
例题:# 各个部门中 最高工资中最低的那个部门的 最低工资是多少?
先考虑取得各个部门最高工资
SELECT MAX(salary) AS max_salary,e.`department_id` did FROM employees e GROUP BY e.`department_id`
结果为:
再将此表命名tmp在进行查询
SELECT MIN(max_salary),did FROM (<