Using the Rank function would be very helpfull for this., possibly a cte.

;WITH Salaries AS (SELECT

EmpID,

EmpLastName,

EmpFirstName,

Salary

RANK() OVER (PARTITION BY EmpID, ORDER BY Salary))

FROM dbo.Employee)AS SalaryRank

SELECT *

FROM Salaries

WHERE (SalaryRank = 10

OR SalaryRank=11)