How to Get All Max ID Record

;with Cte
AS (
SELECT ROW_NUMBER() OVER (
PARTITION BY LeaveID ORDER BY NID DESC
) AS SrNo
,*
FROM tblLeaveNotifications
WHERE EmpCode = 'EMP-0136'
)
SELECT *
FROM Cte
WHERE SrNo = 1