how to query serial number in select statement?

I try querying emp table

select rownum, empno, sal from emp

    ROWNUM EMPNO SAL
---------- ---------- ----------

         1       7369        800
         2       7499       1600
         3       7521       1250
         4       7566       2975
         5       7654       1250
         6       7698       2850
         7       7782       2450
         8       7788       3000
         9       7839       5000
        10       7844       1500
        11       7876       1100
        12       7900        950
        13       7902       3000
        14       7934       1300

I want to order by sal

   select rownum, emp,sal from emp order by dal

    ROWNUM EMPNO SAL
---------- ---------- ----------

         1       7369        800
        12       7900        950
        11       7876       1100
         3       7521       1250
         5       7654       1250
        14       7934       1300
        10       7844       1500
         2       7499       1600
         7       7782       2450
         6       7698       2850
         4       7566       2975
         8       7788       3000
        13       7902       3000
         9       7839       5000

how to Query serial number order by select statement ? Received on Thu Sep 30 1999 - 19:43:37 CDT