Posts by Lucas Garcez • 61 points
1 post
-
6
votes4
answers34297
viewsQ: Take the highest value per category by also loading the ID
The table is in the format below ID | CATEGORIA | QUANTIDADE 1 | A | 23 2 | A | 12 3 | A | 11 1 | B | 15 2 | B | 10 Wanted a query to return to me the following table ID | CATEGORIA | QUANTIDADE 1 |…