Oracle 多列子查询

select *
  from teachers
 where (department_id, wage) in
       (select department_id, min(wage) from teachers group by department_id)

利用此语句，就可以显示多列了。