For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi guys , I am trying to find the nth highest salary
using the below query , is there any case in which the below query can fail
select
* from (
distinct rownum rn,salary from emp_mgr order by rownum) t where t.rn=3
;