Thanks for your answer.I did little modification and still it works with the query: select min(sal) from ( select distinct sal from emp order by...
Hi, Thanks for your reply.I appreciate that. I tried that Query in SQL and it gives the following error: ERROR at line 3: ORA-00907: missing...
How to find third highest salary from emp table in Oracle.?
Separate names with a comma.