Display Second highest value in a Table in SQL Server

Question

Sir I have a table name tbl_Employee the contents are:- emp.ID Name Salary 05 John 5000 08 Rose 4000 10 Mathew 6000 I want to display emp.Id Name and Salary of employee whom salary is second highest in this table please send me the SQL Query

Pankaj Pandey · Answer

try it SELECT * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY SALARY DESC) AS rownumberSalaryempidname FROM tbl_Employee) AS foo WHERE rownumber = 2

Bineesh VP · Answer

Thank You Mr.Pankaj This is absolutely correct answer to my question

Bineesh VP · Answer

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 Pandey · Answer

try it .. SELECT * FROM ( SELECT ROW_NUMBER () OVER ( ORDER BY SALARY DESC ) AS rownumber  Salary FROM tbl_Employee ) AS foo WHERE rownumber = 2