--查詢每個部門工資最低的兩個員工編號锐锣，姓名，工資绳瘟。
select empno, ename,deptno,sal
from emp e
where e.empno in(
select b.empno
from (
select *
from emp
order by sal DESC
) b
where e.deptno=b.deptno and rownum<3
)
order by deptno
SELECT *
FROM emp this
WHERE (
SELECT COUNT(emp.empno)
FROM emp
WHERE emp.deptno = this.deptno
AND this.sal>emp.sal
)<2;
