Hello,
i am using Oracle 11g .Referring scott schema's emp table.
I just issued this sql query with the intention to get second highest salary of a employee. But i am unable to understand why my query fails ?
select rownum,empno,ename,sal from (select empno,ename,sal from emp order by sal desc) where rownum=2;
This query is returning no rows . Can you tell why this query is returning no rows ?