Hi
Row number Partition by member Order by termination date descending
From this All the rows where row number = 1