In a table having a ID_COL column and a SCORE column, for each group of rows with the same value in ID_COL, select the row with the highest SCORE.