if u want select the second highest salary from the emp

table then u have to write query as

select max(salary) from emp where

salary < ( select max(salary) from emp )