Getting top5 salary excluding max salary

Question

Anonymous User · Accepted Answer

Hi,
SQL Server has OFFSET through which you can exclude first
row, so you can just sort the records by salary in descending order and remove
first row, it will give you what you want.
Here is the SQL Query that could help you:
select Salary from Employee ORDER BY salary DESC OFFSET 1 ROWS FETCH NEXT 5 ROWS ONLY

Anonymous User · Answer

You can use ranking to get top 5 salaries excluding the
highest salary
SELECT Top 5 Salary from (SELECT Salary, DENSE_RANK() OVER (ORDER BY Salary Desc) AS Rnk FROM Employee) as emp where emp.Rnk andgt; 1

forum

Getting top5 salary excluding max salary

Royce Roy

Can you answer this question?

3 Answers

Liked By