Select Find Nth Highest Salary Record In Sql Server

Question

Sandeep Singh Shekhawat · Answer

http://www.c-sharpcorner.com/UploadFile/3d39b4/find-nth-highest-salary-in-sql-server/

Anurag Sarkar · Answer

You can use MAX function for this Query will be like this only. select MAX(Salary) from Employee; For more move here:- http://blog.sqlauthority.com/2008/03/12/sql-server-2005-find-nth-highest-record-from-database-table-using-ranking-function-row_number/ Thanks.

Iftikar Hussain · Answer

Hi Try like this using Row_Number --find 3rd higest salary select EmpIdEmpNameSalary FROM( select ROW_NUMBER() OVER(ORDER BY Salary desc) as RowNo *from Employee ) As data WHERE data.RowNo=3 using TOP --find 6th higest salary SELECT TOP 1 EmpIdEmpNameSalary FROM ( SELECT DISTINCT TOP 6 SalaryEmpIdEmpName FROM Employee ORDER BY salary DESC) a ORDER BY salary Regards Iftikar

Abhineet Srivastava · Answer

Check this link: http://www.programmerinterview.com/index.php/database-sql/find-nth-highest-salary-sql/