有如下SQL(基于HROracle11gR2):
selectemployee_id, first_name, last_name, salary
from employees a
where salary = (select min(salary)
from employees b
where b.department_id =a.department_id);
根据department_id分组 查找每个department_id组中薪水最少的员工信息
上面的SQL会扫描employees表两次可以利用如下分析函数只让Oracle扫描