TO FIND THE Nth SALARY QUREY

1. select M,address,salary from(select rownum M,address,salary from(select rownum,address,salary from ela order by salary desc))where M=&k;

 2.select R,salary,address from(select rownum R,salary,address from(select rownum,salary,address from ela order by salary desc))where R=10;

 EX:-

select R,sal from(select rownum R,sal from(select rownum,sal from emp order by sal desc))where R=3;