Oracle SQL脚本记录

--查询各部门中工资最低的员工信息
--方法一
select *
  from emp
 where (empdept, empsaler) in
       (select empdept, min(empsaler) 
          from emp 
         group by empdept);

--方法二
select emp.*
  from emp
 inner join (select empdept, min(empsaler) minsaler
               from emp
              group by empdept) temp
    on emp.empdept = temp.empdept
   and emp.empsaler = temp.minsaler