0

I have a table that looks like this:

id initials score
0 ABC 45
1 ABC 46
2 CBA 46

How can I select the values where the initials are distinct and that the score is the highest possible for that initial?

For example the table shown before should return:

id initials score
1 ABC 46
2 CBA 46

0 Answers0