find out particular salary(nth salary)

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 660
select * from employees where
salary in(sELECT salary
FROM
(select rownum sno,salary from(select salary
from employees order by salary desc)s)
WHERE sno=3)

Comments or Responses

Login to post response