Hi the below query should work in retrieving the second highest salary from the table. Select max(salary) from emp where salary not in(select max(salary) from emp);