remove duplicate records based on highest value in one of the column

[Preet2020]

I'd like to remove duplicate records based on ID. For the duplicated record, a check needs to be done in the BRANCH column and retain the record which has the highest value in BRANCH column. I also have unique records so those records should be retained in the output. Please advise

INPUT
ID	BRANCH
AF54WE	7895433
AF54WE	67548
NM765	45789
HJLN67	9887654
HJLN67	6321
YG8790	1567
YG8790	2238865

OUTPUT
ID	BRANCH
AF54WE	7895433
NM765	45789
HJLN67	9887654
YG8790	2238865

[aatalai · Accepted solution]

@Preet2020 try this hope it helps

[MilindG]

@Preet2020 One way to do this