Thanks for all the replies... especially racosta & guarddata.

We do not have any primary key, Identity, Date_Entered fields on this table.

I pulled the required records with this query....

SELECT *

from table1

where field1code = (select max(field1code)

from table1)

I have a Clustered Index on field field1code. As racosta and guarddata pointed, I have used the index field and got this...

guarddata : Thanks for letting me know an important point. I didn't know that the query will be running on the background even after displaying the results. Nice insight.

Thanks to all again....