This is a simple way to start. You might have to adjust the logic to determine what row you want to be returned.

CREATE TABLE #temp (empid INT, empname VARCHAR(50), managerID INT, empWage MONEY)

INSERT INTO #temp

SELECT 1001, 'Lucky101', 1005, 1000.00

UNION ALL

SELECT 1002, 'Lucky102', 1005, 2000.00

UNION ALL

SELECT 1003, 'Lucky103', 1005, 3000.00

UNION ALL

SELECT 1004, 'Lucky104', 1005, 4000.00

UNION ALL

SELECT 1005, 'Lucky105', 1010, 5000.00

UNION ALL

SELECT 1006, 'Lucky106', 1010, 6000.00

;WITH CTE AS

(

SELECT *, ROW_NUMBER() OVER (ORDER BY empWage desc) AS rowNum

FROM #temp

)

SELECT * FROM cte

WHERE rowNum = 4

DROP TABLE #temp