1
2
3
4
5

SELECT TOP 1 ID, FirstName, LastName, Salary, Role FROM
(SELECT *,
	ROW_NUMBER() OVER(ORDER BY Salary DESC) AS _RN
	FROM Staff) S
WHERE _RN = 3;