select deptno, ename, sal
from emp e1
where
(
select count(*)
from emp e2
where e2.deptno=e1.deptno and e2.sal<e1.sal
) <2
order by deptno, sal;
查询每个部门工资最低的两个员工的编号,姓名,工资
最新推荐文章于 2024-05-02 17:05:40 发布