Hi,
As you are having multiple records for multiple employees to find the latest record you have to use "
Order By" clause with "Descending" property.
Then you have to use "
Group By" clause to group your employees.
Then you have to select the "
Partition By" record from the descending order based on the
employeeID and select the top one record.
Hope you got the logic to implement the solution here.
For reference
use this link.
Thanks
Sisir Patro