Discussions

EJB design: first 3 highest salary from emp table in oracle.

Bookmark and Share Get thread feed

  1. first 3 highest salary from emp table in oracle. (4 messages)

    hi, can anyone plz tell me how to find the only first 3 highest salary from emp table in oracle.

    I have used order by desc but it shows all the sal of all employees

    regards
    Sukhbir
    Reply to this

    Threaded Messages (4)

  2. first 3 highest salary from emp table in oracle.[ Go to top ]

    You could use the rownum variable to list the top three

    Select xxxx
    from yyy
    where
    zzz = ??? and
    rownum
    Reply to this Reply to original

  3. first 3 highest salary from emp table in oracle.[ Go to top ]

    select top 3 sal from employee order by sal
    Reply to this Reply to original

  4. Reply[ Go to top ]

    Sukhbir,

    You should use rownum, however, remember, that rownum doesn't work with order properly, so you should use subquery:

    select * from (select * from emp order by sal) where rownum<3

    That should work.

    Alex
    Reply to this Reply to original

  5. first 3 highest salary from emp table in oracle.[ Go to top ]

    select * from (select distinct salary from ran1  order by salary desc)where rownum<=3;

        SALARY
    ----------
         20000
         14000
         12000

    Reply to this Reply to original