Row over partition problem

i have the following table

ID,CODE,ROW
4,50,21
8,50,26
8,50,28
8,50,29

What would like in the out put is the distinct ID, If a ID is there multiple times show only the ID with the max row

expected output

ID,CODE,ROW
4,50,21
8,50,29

ignore this i figured it out

thx