write a query to n-th highest salary.

Question

Ravi Vishwakarma · Answer

To retrieve the n-th highest salary from a SQL Server table, you can use a similar approach to the previous query, but adjust the
ROW_NUMBER() function and filtering criteria. Here's how you can write a query to get the n-th highest salary:
DECLARE @N INT = 3; -- Change this value to the desired N-th highest salary
SELECT TOP 1 Salary
FROM (
 SELECT Salary, ROW_NUMBER() OVER (ORDER BY Salary DESC) AS RowNum
 FROM YourTableName
) AS SalaryRanked
WHERE RowNum = @N;
In this query:
Inner Query (SalaryRanked): This subquery selects the
Salary column from your table (YourTableName) and assigns a row number (RowNum) to each row based on the descending order of
Salary.
Outer Query: The outer query selects the Salary from the
SalaryRanked subquery where the RowNum equals @N.
@N is a parameter that you can adjust to retrieve the desired n-th highest salary. In the example above,
@N is set to 3, so it will retrieve the third-highest salary.
Adjust the @N variable to fetch the n-th highest salary you're interested in from your table. This query will effectively fetch the specified n-th highest salary based on the sorting of the
Salary column in descending order.
Read moreand 
Write a query to get the second-highest salary.

interview

write a query to n-th highest salary.

Ravi Vishwakarma

1 Answers

Liked By