select * from MyTable
where field1 = (select max(field1) from MyTable)