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....
.