select *
from teachers
where (department_id, wage) in
(select department_id, min(wage) from teachers group by department_id)
Oracle 多列子查询
最新推荐文章于 2024-05-13 09:32:24 发布
select *
from teachers
where (department_id, wage) in
(select department_id, min(wage) from teachers group by department_id)