Rownum not woking in found highest salary

Question

select * from (select * from (select emp_salary from employee order by emp_salary) where rownum<6 order by emp_salary)where rownum =6;

in above query rownum is not working , if i will run below query then rownum is working, i am confussed about it please help

select * from (select * from (select emp_salary from employee order by emp_salary) where rownum<6 order by emp_salary)where rownum =1;

Rownum is the row ordinal for every row returned to the consumer. It cannot skip value 1 by definition — astentx, Jul 04 '23 at 17:01

score 0 · Answer 1 · answered Jul 04 '23 at 16:46

Can you try with:

  select * 
   from (
         select rownum as num_row, x.* 
           from (
                 select emp_salary 
                   from employee 
                  order by emp_salary
                ) x
          where rownum <= 6 
          order by emp_salary
        ) 
  where num_row = 6;

Thanks.

Rownum not woking in found highest salary

1 Answers1