Hey,
I’ve got a tbl with non-unique IDs and type.
I want to query the tbl for one instance of each ID and the highest type.
So looking at the tbl below
ID Type
A 1
A 2
B 2
B 3
I want to return the data below only
ID Type
A 1
B 2
Can anyone help me?
Regards,
C