Use the below Query:

Select Max(salary) from Emp 
Where Max(salary) < (Select Max(salary) from emp
                     where emp-no=101);

select max(salary)
from Emp
where rownum < 2;

select top 1 emp_total_sal,emp_name from (
select top 2 emp_total_sal,emp_name  from employee_table 
ORDER BY emp_total_sal DESC)  a
ORDER BY emp_total_sal ASC

I write the query for this question using OLAP functions.

 select  e1.* from (select ename,sal,rank()
 over(order by sal desc) rank from emp) e1
 where e1.rank=2;

SELECT salary 
FROM (SELECT salary FROM emp
      ORDER BY DESC salary)
WHERE RowNum=2

to select the nth highest salary from emp table

select distinct(a.sal) from emp a where &n=
(select count(distinct(b.sal))from emp b where a.sal<=b.sal);

select max(sal) from emp where sal<select max(sal) from emp

select max(sal) from Emp where sal < (select max(sal) from 
Emp)

select ename,salary from emp
where rownum=2
order by salary desc

select ename,salary from (select rownum,ename,salary from 
emp
order by desc) where rownum=2;

SELECT sal
FROM (SELECT sal FROM emp
      ORDER BY sal desc)
WHERE RowNum<=2
minus
SELECT sal
FROM (SELECT sal FROM emp
      ORDER BY sal desc)
WHERE RowNum<=1

select  e1.* from (select ename,sal,rank()
 over(order by sal) rank from emp) e1
 where e1.rank=2;