Display Second highest value in a Table in SQL Server

Pankaj Pandey13y ago

Accepted answer

try it

SELECT * FROM (

SELECT ROW_NUMBER() OVER (ORDER BY SALARY DESC) AS rownumber,Salary,empid,name

FROM tbl_Employee)

AS foo

WHERE rownumber = 2

Bineesh Viswanath13y ago

Thank You Mr.Pankaj

This is absolutely correct answer to my question

Bineesh Viswanath13y ago

Thank You Mr.Pankaj.

The Code is working correctly, but is there any query to display emp.Id and salary instead of row number and salary in the above query?

Pankaj Pandey13y ago

try it ..

SELECT * FROM (

SELECT ROW_NUMBER() OVER (ORDER BY SALARY DESC) AS rownumber,Salary

FROM tbl_Employee)

AS foo

WHERE rownumber = 2