Tuesday 21 June 2011

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;

No comments:

Post a Comment