SQL statement for getting highest salary

Question

Hi What is SQL statement for getting n'th highest salary? Thanks.

Jignesh Trivedi · Answer

Hi try this. select * from( SELECT empId salary ROW_NUMBER()OVER(PARTITION BY salary ORDER BY salary ) as RowNum from ExaminationOptions) A where A.RowNum =n order by a.rownum desc hope this help.

Dhaval Patel · Answer

Dear Alok use this query for nth Highest Salary SELECT TOP 1 salary FROM ( SELECT DISTINCT TOP n salary FROM employee ORDER BY salary DESC) a ORDER BY salary where n > 1 (n is always greater than one) use below link for your reference http://blog.sqlauthority.com/2008/04/02/sql-server-find-nth-highest-salary-of-employee-query-to-retrieve-the-nth-maximum-value/ http://www.c-sharpcorner.com/Blogs/7111/how-to-get-second-highest-and-lowest-record-in-sql-server.aspx thanks & Regards Dhaval Patel This post help you than Mark As Accepted Answer