I have a table similar to following:
Country City Sales
USA NY 100
USA SF 500
USA BO 200
UK LO 300
UK BE 700
UK MA 400
and I want to select out the top city in each country based on sales
so the result-set from the above should be:
USA SF 500
UK BE 700

Can this be done using one SQL statement ?

Regards,
Gerard