To find out second highest salary in Sql Server

Hi Rama,

Select max(salary) from employee where salary NOT IN
(Select max(salary) from employee)

or

General Syntax for Nth highest salary

select distinct(salary)  from employee A where n=(select count(distinct(salary)) from employee B where A.salary<=B.salary)

For 2nd highest salary

Here n=2

select distinct(salary)  from employee A where 2=(select count(distinct(salary)) from employee B where A.salary<=B.salary)



Thanks

Dear rama krishna

Please click below link for second highest and lowest record find in Sql Server

http://www.c-sharpcorner.com/Blogs/7111/how-to-get-second-highest-and-lowest-record-in-sql-server.aspx


This post help you then mark as "Accepted Answer"

There are some fancy solutions to this problem in this thread:

http://stackoverflow.com/questions/7417415/how-to-get-second-highest-salary-employees-in-a-table

In practice, I think most folks would just do this and then use the second row returned by the query:

SELECT DISTINCT TOP (2) salary FROM employee ORDER BY salary DESC

SELECT TOP 1 salary
FROM (SELECT DISTINCT TOP 2 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary