[Solved] Find most recent Status for each Employee, based on annual updates

by


This should do it:

SELECT e.[Name],
       e.[Year],
       e.[Status]
FROM employee AS e
     INNER JOIN
(
    SELECT [Name],
           MAX([Year])
    FROM employee
    GROUP BY [Name]
) AS m ON e.[Name] = m.[Name]
          AND e.[Year] = m.[Year];

solved Find most recent Status for each Employee, based on annual updates