1  select deptno,ename,job
  2  ,rank() over (partition by deptno order by job) r
  3  ,(select count(*) from emp e2 where e2.deptno=e.deptno and e2.job<e.job)+1 rs
  4* from emp e
SQL> /

    DEPTNO ENAME      JOB                R         RS
---------- ---------- --------- ---------- ----------
        10 MILLER     CLERK              1          1
        10 CLARK      MANAGER            2          2
        10 KING       PRESIDENT          3          3
        20 SCOTT      ANALYST            1          1
        20 FORD       ANALYST            1          1
        20 ADAMS      CLERK              3          3
        20 SMITH      CLERK              3          3
        20 JONES      MANAGER            5          5
        30 JAMES      CLERK              1          1
        30 BLAKE      MANAGER            2          2
        30 MARTIN     SALESMAN           3          3
        30 WARD       SALESMAN           3          3
        30 ALLEN      SALESMAN           3          3
        30 TURNER     SALESMAN           3          3

14 rows selected.