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...
Thanks for your reply.I appreciate that.
I tried that Query in SQL and it gives the following error:
ERROR at line 3:
How to find third highest salary from emp table in Oracle.?
Separate names with a comma.