RANK

     This will give the non-sequential ranking.

     Ex:

          SQL> select rownum,sal from (select sal from emp order by sal desc);

    ROWNUM    SAL

    ---------- ----------

         1       5000

         2       3000

         3       3000

         4       2975

         5       2850

         6       2450

         7       1600

         8       1500

         9       1300

        10       1250

        11       1250

        12       1100

        13       1000

        14        950

        15        800

     SQL> select rank(2975) within group(order by sal desc) from emp;

RANK(2975)WITHINGROUP(ORDERBYSALDESC)

---------------------------------------------------------

                                    4