Hi

> select field2 from table where field1 = ( select max(field1) from table )

What about

select first 1 field2 from table order by field1 desc

Regards,
Steffen