And what happens if the bottom 5 people have the worse wage, and what you want is the 6th person (2nd lowest wage)? You might want to use the RANK() function.

declare @TopWagePosition int;

set @TopWagePosition = 2;

WITH CTE AS

(

SELECT EmpID,

EmpWage,

RN = RANK() OVER (ORDER BY EmpWage DESC)

FROM EmpDetails

)

SELECT *

FROM CTE

WHERE RN = @TopWagePosition;

You might want to see this article for how all of the Windowing Functions work: SQL Server Ranking Functions[/url]