I have a layer which contains a unique ID (UID) for each feature and another column of Scores.
For example:
UID, Score
A12,1
A13,1
A14,4
A12,2
A13,3
A14,5
I would like to use an SQL statement to group the data by their UID value and return the highest score.
For example, using the table above, A12 would equal 2, A13 = 3 and A14 = 5.
There appears to be several locations where I could complete this SQL statement?
Which is the correct Query Builder to use and how do you complete this query in SQL?