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

SELECT TOP 1 empid,empWage
FROM
(
	SELECT TOP 4 empid,empWage 
	FROM Empdetails
	ORDER BY empid DESC
) a 
ORDER BY a.empid ASC

SELECT TOP 1 EmpID, MAX(EmpWage) AS [Max Wage]
FROM EmpDetails
GROUP BY EmpID
HAVING MAX(EmpWage) < (SELECT TOP 1 MAX(EmpWage) FROM EmpDetails)
ORDER BY [Max Wage] DESC

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;