Pull distinct value from database

[johnsmith153]

 

 

field1 / field2

10  /  England

15  /  Italy

20  / France

15  /  France

30  /  USA

 

When searching for France:

SELECT DISTINCT field2, field1 FROM $tableName would return a distinct value. I want to ensure it returns the highest value in field1.

 

Something like this:

 

SELECT DISTINCT field2 (but ensure returns highest field 1 value), field1 FROM $tableName

[Adam]

You can use:

 

SELECT DISTINCT MAX(field2), field1 FROM $tableName