Hi all, I have this table, i need to use query to get one row from each group A, B and C, could be more if table is bigger, and this row from the specific group has to have highest mpt among the rows found within the group, and i can guarantee there is only one in each group in the big table below,
cat time level pt mpt A 1 A1 7 0 A 2 A3 3 3 B 3 A2 4 0 C 1 A3 1 1 C 2 A1 9 0
And the resulting table should look like this...
cat time level pt mpt A 2 A3 3 3 B 3 A2 4 0 C 1 A3 1 1
Please help, thanks.