Delete assignment record

We are trying to delete the assignment records and remain the first one(which is Hire) , not sure if thats could be done by bulk? if someone could advise how to delete that via HDL？ Or any other ways would be appreciated.

Thanks.