> Hello,
>
> Is it possible to optimize this query:
>
> select
>         field2
> from
>         table
> where
>         field1 = ( select max(field1) from table )
>
>

what's wrong with
select max(field1), field2 from table

Alan