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 |