asked
Returning max date record with a year for each employee
I have say ten employees (empi) Each has at least two records per year (Year) Each record has start date that differs (Startdate) Employees records exist over many years I want to use Max to select the record with the latest Startdate for each Year for each employee ie Each employee will only have one row for each year Thank you
If you include the YEAR in both the SELECT- and GROUP BY clauses you'll get the max per year.
18 People are following this question.
