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
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