>>If you have an index on Field2, the following code will give you all records, which have max Field2:
>>
>>select field1, field2 from Table1 where field2 in (select max(field2) from table1)
>
>Nadya,
>
>It seems to me that the SELECT you posted doesn't require any index (except for optimization).
>
>Hilmar.
Yes, this is what I meant.
If it's not broken, fix it until it is.
My Blog