write a query to select second highest salary of the employee from the employee table?

hi
for second highest salary in employee table
select max(salary) from employee where salary<(select max(salary) from employee)
it is very short and easy to understand for any one

Hi Aswinialuri & Jitendrasoft09,

Thank you so much for the responses. This place is dedicated only to post the responses of the above mentioned question. If you find a better way of answerring it kindly get back to us by posting a new question then we shall review it and approve.

Thank you so much for your co-operation

Moderator Interview Section

Hi,

For getting Second Highest Salary:

Select min(salary) from Employee where salary in (select top 2 salary from Employee order by salary descending )

First In subquery will be select top 2 salary order by descending, then in Top 2 salary will be select the minimum salary, which would be second highest salary.

Thanks