SQL statement for getting highest salary

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.

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