Delete rows based on highest value

Hi all, I wondered if you could help on this one, I have a table where I want to keep the row with the lowest value, so with this example


a b
cx121 5
cx122 7
cx122 8
cx123 9
cx121 4


the result I would need is

a b
cx121 4
cx122 7
cx123 9


Any help would be really appricated.

Maybe:

Please Login or Register  to view this content.