General information
Category:
Coding, syntax & commands
Title:
Sql select using Max
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only