select d.dname, d.loc, e.ename
from dept d,
     (select ename, sal, deptno, rownum no
      from (select *
            from emp
            where deptno in (10, 20)
            order by sal desc)) e
where d.deptno = e.deptno
      and e.no between 3 and 5;