display the 5th lowest sal from emp table using Correlated subquery

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Select * from Hello h where 5=(select count (distinct amt) from hello where h.amt>amt)

This will give the 5th record from lowest

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli Questions by srikanth.cherukupalli

• Mar 1st, 2012

Select rank,salary from (select rownum as rank, salary from (select distinct(salary) from emp order by salary)) where rank=5;

Answer Question  Select Best Answer