Re: fist three higher values

Here is one example - using the EMP table in the SCOTT schema

SQL> describe scott.emp

 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------------


----

 EMPNO                                     NOT NULL NUMBER(4)
 ENAME                                              VARCHAR2(10)
 JOB                                                VARCHAR2(9)
 MGR                                                NUMBER(4)
 HIREDATE                                           DATE
 SAL                                                NUMBER(7,2)
 COMM                                               NUMBER(7,2)
 DEPTNO                                             NUMBER(2)

SQL> select sal from scott.emp
  2 where rownum < 4
  3 order by sal desc;

       SAL

      1600
      1250
       800

SQL> Received on Thu Jan 31 2002 - 05:50:02 CET