Highest Salary in the employee table?

Select empno,ename,sal,deptno from
(select empno,ename,deptno,sal rank() over(order by sal,deptno) rank
from emp) where rank=2;