find third highest salary of employee

Discussion in 'Databases' started by viron86, Nov 19, 2008.

0
  1. #1
    sql query in oracle to find third highest salary of employee
    without using set operators and ronum
     
    viron86, Nov 19, 2008 IP
  2. Pos1tron

    Pos1tron Peon

    Messages:
    95
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Such a query is nigh impossible for us to write properly as we have absolutely no idea of field names, datatypes, structures, etc etc...
     
    Pos1tron, Nov 29, 2008 IP
  3. pondlife

    pondlife Peon

    Messages:
    898
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    0
    #3
    select * from employees where salary < ( select max(salary) from employees ) order by order by salary desc limit 0,3;

    just a guess! :)
     
    pondlife, Nov 30, 2008 IP
  4. pharmboy

    pharmboy Member

    Messages:
    30
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    43
    #4
    Why would you not want to use rownum?
     
    pharmboy, Dec 1, 2008 IP
  5. pondlife

    pondlife Peon

    Messages:
    898
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    0
    #5
    The employees salary might not have been entered into the database in order?
     
    pondlife, Dec 3, 2008 IP
  6. viron86

    viron86 Active Member

    Messages:
    426
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    60
    #6
    i was asked this question in exam
     
    viron86, Dec 3, 2008 IP