Previous Termination Date and Assignment Number

Summary

Previous Termination Date and Assignment Number

Content

Hi Guys,

Its my first time in here. Just want to know if there's a way to get the previous assignment number and termination date from my list and removing the duplicates. Attached is a screen shot of my table and more detailed info to what I trying to achieve. 

in the Main table, I'm trying to remove the duplicate in the PREV_ASSIGN and PREV_TERMINATION column.

the Table result is what the table should look like, it should be showing only two rows. is there a way to achieve this result, I'm trying some SQL code but no luck its still showing duplicates. below is current SQL code. I really need some help, I not a that knowledgeable in SQL so I'm out of options.