Rownum and sort

As everyone knows, "ROWNUM" column in Oracle displays row number in order like this:

SQL> select rownum, empno, ename, job from emp;

    ROWNUM EMPNO ENAME JOB
---------- ---------- ---------- ---------

         1       7369 SMITH      CLERK
         2       7499 ALLEN      SALESMAN
         3       7521 WARD       SALESMAN
         4       7566 JONES      MANAGER
         5       7654 MARTIN     SALESMAN
         6       7698 BLAKE      MANAGER
         7       7782 CLARK      MANAGER
         8       7788 SCOTT      ANALYST
         9       7839 KING       PRESIDENT
        10       7844 TURNER     SALESMAN
        11       7876 ADAMS      CLERK
        12       7900 JAMES      CLERK
        13       7902 FORD       ANALYST
        14       7934 MILLER     CLERK

14 rows selected.

My problem is the fact that rownum is rearranged when I do "order by", like this:

SQL> select rownum, empno, ename, job from emp order by ename;

    ROWNUM EMPNO ENAME JOB
---------- ---------- ---------- ---------

        11       7876 ADAMS      CLERK
         2       7499 ALLEN      SALESMAN
         6       7698 BLAKE      MANAGER
         7       7782 CLARK      MANAGER
        13       7902 FORD       ANALYST
        12       7900 JAMES      CLERK
         4       7566 JONES      MANAGER
         9       7839 KING       PRESIDENT
         5       7654 MARTIN     SALESMAN
        14       7934 MILLER     CLERK
         8       7788 SCOTT      ANALYST
         1       7369 SMITH      CLERK
        10       7844 TURNER     SALESMAN
         3       7521 WARD       SALESMAN

14 rows selected.

SQL> Is there any way to get around this, so that rownum is displayed in order even when I do sort? Thank you in advance.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 08 2000 - 09:04:20 CST