Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

How to find second highest salary from table

Manish Kumar 1604 08 Nov 2017

Manish Kumar

Other

1 Answers

Manish Kumar 08 Nov 2017

there are many ways to solve this problem one of them is

select MAX(Salary) from Employee WHERE Salary NOT IN (select MAX(Salary) from Employee

and anotother is

SELECT TOP 1 salary FROM (

   SELECT TOP 2 salary 

   FROM employees 

   ORDER BY salary DESC) AS emp 

ORDER BY salary ASC

MindStick Training